PeopleSoft BI Publisher: Group Formulas Containing Fields
I have a simple RTF template that looks like this:
The template is attached as "CORGL102 detail formula test.rtf", and the sample data is attached as "CORGL102_BIP.xml".
The code for this per Field Browser is:
Preview looks like this:
The formula <?xdofx:EXP12_3 DIV EXPR46_46?> works, however distinct values are required in the Account column and sums in the amount columns, so the template is changed to group accounts instead like this:
The template is attached as "CORGL102 group formula test.rtf".
The code for this per Field Browser is:
Preview looks like this:
Thus the sum of distinct account rows is working but the formula is not.