| How to Calculate Sum in Xml Publisher Reports [message #458682] |
Tue, 01 June 2010 04:33  |
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
|
Senior Member |
|
|
I am using MS-Word 2003, Xml publisher 5.6.3, and Oracle Applications R12.
While creating layout design in 'RTF' format i want to calculate sum of 'sal' field without using any formula column in rdf.
I want to perform calculations in xml publisher only.
with reference to xml publisher user guide it is possible through Field(Field Properties). By using 'Format' and 'Calculate' Tabs.
But i dont know how to create a field place holder column.
i am familiar with form text field only.
I am attaching the RTF, and Field Properties Screen shots(which i don't know how to create).
Please help me how to create a field.
|
|
|
|
|
|
|
|
| Re: How to Calculate Sum in Xml Publisher Reports [message #525679 is a reply to message #459391] |
Tue, 04 October 2011 11:02  |
 |
ravelapk
Messages: 1
Registered: October 2011
|
Junior Member |
|
|
Can someone help me to write the sum of a calculated column in xml publisher?
I've totally 6 columns, all the columns have data, and 3 of them were modified as..
<?if:SHIP_TO!='347'?><?INTR_UNIT_COST?><?end if?>
<?if:SHIP_TO!='347'?><?CF_INTRANSIT_TRANS_COST?><?end if?>
<?if:SHIP_TO='347'?><?TRANSACTION_QUANTITY*TRANSFER_PRICE?><?end if?>
<?if:SHIP_TO!='347'?><?CP_FRT_AMOUNT?><?end if?>
Now I need the sum for the above second modified column output. IF I do <?sum(CF_INTRANSIT_TRANS_COST)?>, it's not taking the values after the modification. Instead it's summing up the original data.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
