Home » Fusion Middleware & Colab Suite » Business Intelligence » How to Calculate Sum in Xml Publisher Reports (Microsoft Office word 2007)
How to Calculate Sum in Xml Publisher Reports [message #590312] Wed, 17 July 2013 01:22
Messages: 66
Registered: March 2013
Location: delhi

How to calculate the grand total,when there is a condition in the field.
I have a problem in sum of the field,Because of some reason.

i have XML

<?if:ITEM_TYPE='FG'?><?QT?><?end if?><?if:ITEM_TYPE='SA'?><?CS_1?><?end if?><?if:ITEM_TYPE='OP'?><?QT?><?end if?>

now i have right record in that field according to items .

But the sum is not coming right .

when i am doing sum(QTY).

I tried grouping also.But data is not coming that with also

Please help.

[Updated on: Wed, 17 July 2013 01:31]

Report message to a moderator

Previous Topic: Bi Pulisher issue
Next Topic: Multiple Excel output files
Goto Forum:

Current Time: Fri Aug 18 03:39:23 CDT 2017

Total time taken to generate the page: 0.09732 seconds