BI Publisher (MOSC)

MOSC Banner

subtraction calculation in RTF template

edited Dec 4, 2013 10:25AM in BI Publisher (MOSC) 6 commentsAnswered ✓

I am working on an Oracle XML Publisher procurement report (Oracle E-Business Suite R12) that starts with a budget amount that is imported from our financial system, then lists all requisitions and orders that are in process (not approved).  The amounts of all those unapproved requisitions/orders are totaled using a Sum form field, to be followed by a field where the unapproved requisition/order total is subtracted from the budget amount (amount available).  This is the code I used in my form field for the amount available:

<?xdofx:BUDGETAVAILABLE-(sum (EXTENDED_COST))?>

When the report is run, all the fields are successfully populated, except for the Amount Available -- it lists the original budget amount, but does not subtract the sum of the extended cost.

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