PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center