| Conditional if statement using two XML tags [message #626599] |
Wed, 29 October 2014 14:03 |
d0dger
Messages: 7
Registered: July 2000
Location: South Dakota
|
Junior Member |
|
|
Very new to BI Publisher.
I have the following data in my XML output.
<CF_ORDER_TOTAL>10265</CF_ORDER_TOTAL>
<CP_SHIPMENT_TOTAL>10265</CP_SHIPMENT_TOTAL>
</G_QUOTE_HEADER>
When I set my if statement to:
<?if:CF_ORDER_TOTAL != '' ?>
and the value of CF_ORDER_TOTAL is not NULL it prints the frame of data that I need on my report.
Users have asked that the data not print unless the sum of :CF_ORDER_TOTAL and :CP_SHIPMENT_TOTAL is greater than 5000.
I modified the if statement to:
<?if:CF_ORDER_TOTAL+:CP_SHIPMENT_TOTAL > 5000 ?>
but it finishes in error. I tried surrounding the addition with parenthesis but that also did not work. My Google searches have not produced and results either.
Any help would be greatly appreciated.
Thank you.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
