Oracle BIP Report Not Summing

Sofia Danielle Sarmiento

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.

Mallikarjuna Kuppauru-Oracle

Hi @Sofia Danielle Sarmiento

Can you refer below MOS doc -

What is the Syntax to Sum within a Group in a BIP RTF template ? (Doc ID 2635593.1)

https://docs.oracle.com/middleware/12212/bip/BIPRD/GUID-26901946-7CDC-412C-A004-E7209F669ED6.htm#GUID-26901946-7CDC-412C-A004-E7209F669ED6

Regards,

Arjun

_vero_

Hi Sofia,

I had the same problem in one of my publisher reports, where I couldn't aggregate the data into a repetitive group. I solved it by directly modifying the data model, modifying the dataset query with a group by, in such a way as to display everything directly in publisher, without aggregating in the rtf.

Let me know if it can be done in your case

Regards

Veronica