DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

summing the values based on the if condition

3176403May 16 2016 — edited Jun 14 2016

Hi all,

I have an issue in XML Bi Publisher(11). My requirement is based on the CF_1, the records are filtered. If CF_1=1 then the row will be displayed else the row will be hidden. Now i want the sum of shown records only. I have taken the field in my rtf sum(CF_BOQ_VAL). It is showing sum of all values not based on the condition. Please help me in solving this issue. I am enclosing the xml output and try to build the rtf by using All fields. Try to insert an additional field which is sum(CF_BOQ_VAL) (11TH column).

This post has been answered by tsuji on May 16 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2016

Added on May 16 2016

#general-xml, #xml

9 comments

5,798 views