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:
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.
Note: The formula that successfully calculates the total extended cost form field is <?sum (EXTENDED_COST)?>. This where I got the second part of my formula.
plz post sample xml
looks like you need to change logic like
- calc sum (EXTENDED_COST) and save it in variable
- use variable in calc (BUDGETAVAILABLE-variable)
related Summing a calculation