Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to find the sum total of an element for all the groups in rtf template?

in BI Publisher Learning Center

Hi,

I am working on an RTF template for Oracle BI Publisher and I am trying to get the total sum of amount for all the groups in the template.

The scenario is there are 3 groups in the xml file based on the Tax Code and I want the total sum of Net Amount for each group combined together.

I am using <?sum(SUM_NVL_CLINE_EXTENDED_AMOUNT_0__[.!=’’])?> where SUMNVL_CLINE_EXTENDED_AMOUNT_0_ is the tag for Amount.

This is giving incorrect value. Can you please help with this?

Regards,

Kratika

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!