Home » Fusion Middleware & Colab Suite » Business Intelligence » Conditional if statement using two XML tags (XML Publisher, 11.5.10.CU2, Solaris SPARC 11)
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.
Previous Topic: Nested If
Next Topic: Trouble with BI Publisher. Text which is divided into columns is printed on separated page.
Goto Forum:
  


Current Time: Mon Mar 18 22:08:50 CDT 2024