BI Publisher (MOSC)

MOSC Banner

How do I run Functions based on results of "If statements"?

edited Aug 1, 2013 2:56AM in BI Publisher (MOSC) 3 commentsAnswered
I have two columns in my template: One to show the sum of Ship Weight for EU countries and the other to show the sum of Ship Weight for Non-EU countries.  How do I correct my syntax?  I have the following within the syntax properties of one field.
EU field: <?if:EU_ID='EU'?><?SUM((Weight_ID1)*(Quantity_Shipped_ID2))?><?end if?>
Non-EU field: <?if:EU_ID!='EU'?><?SUM((Weight_ID1)*(Quantity_Shipped_ID2))?><?end if?>

My RTF template validates, but when I try to run a PDF output, it gives me an error.  Do the if statements need to be outside the field?  Do I need to incorporate for-each or for-each-group statements instead?  If so, how?  Thanks in advance.

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