Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle BIP Report Not Summing

Received Response
27
Views
2
Comments

I need your help in my RTF template that has a sum for every each segments.

  1. I added the field in the cell, set the Calculation to Sum and checked the Grouping.
  2. Generated the report and it's giving "0.00" in value instead of 5,149.999.96 (DEBITS Column) 

Here's the report layout: 

I would appreciate any help. I'm not sure if the sum is already not working in the BIP reports or I just misconfigured something in the template.

Thank you in advance.

  1. I already tried clearing the Repeating Groups but the sum is still not working.
  2. I tried unchecking the Grouping, but it's giving incorrect sum.

My expectation is it would sum the values in a column.

Answers