Hi Brajesh The correct template is being picked up because if I take out the contains the template works just produces the output with both categories. I honestly think that it is to do with the Advanced pricing Price book generation that it is not recognising the string function. Regards Rick

You little genius. That worked. Thankyou so much.

Hi Brajesh Thanks for your reply. When you said that it worked for you, do you mean it worked in template viewer or word preview? The code as posted works in both of those tools. The issue with changing the statement to <?if:contains(CategoryName,'/')?> is that it provides an incorrect answer in preview (There are two…

Hi Brajesh Could you confirm that you get similar lines in the attached output in template viewer? I have included two tables. They produce different results. The first table is using <?if:contains(current-grouping-key(),'/')?> The second table is using <?if:contains(CategoryName,'/')?> Regards Rick

Expected output

Hi Brajesh This field is current-grouping-key(). The layout is a copy from the Oracle seeded Price book summary report. Regards Rick

Hi I tried this as well in template viewer but the filter on the group produced random results. The problem will still be that the Oracle Advanced Pricing module doesn't like "contains" (or any other string function) in the layout when producing a price book. My requirement is to use the seeded pricing engine to produce a…