BI Publisher (MOSC)

MOSC Banner

How to calculate Total based on Formula Value in xml publisher template

edited Jan 7, 2014 6:45AM in BI Publisher (MOSC) 25 commentsAnswered
Hi,

I have issue ro create a formula to calculate Total. The calculate column is not direct xml tag field but formula column.

How can I do this?

Following is a example…

Let see order has 2 lines with qty, price, and discount. I am using following formula to get Line Amount. Both lines are in same group and using same this formula:

<?if:DISCOUNT_PCT = ''?><?(LINE_UNIT_SELLING_PRICE)* (LINE_QTY_ORDERED) ?><?end if?><?if:DISCOUNT_PCT !=''?><?((LINE_QTY_ORDERED*LINE_UNIT_SELLING_PRICE)-((LINE_QTY_ORDERED*LINE_UNIT_SELLING_PRICE)* (DISCOUNT_PCT*0.01)))?><?end if?>

                                                                                          Line Amount 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center