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
bhawnakaamra
Messages: 66
Registered: March 2013
Location: delhi
Member
Hello,

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: Sat Nov 29 03:57:19 CST 2014

Total time taken to generate the page: 0.06067 seconds