OraFAQ Forum: Business Intelligence » How to Calculate Sum in Xml Publisher Reports

Home » Fusion Middleware & Colab Suite » Business Intelligence » How to Calculate Sum in Xml Publisher Reports (Microsoft Office word 2007)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 00:04:00 CDT 2024