Hiding multipe rows in a for loop

Question

Summary

Content

Hi All,

I have a requirement where in the report if there are similar "Transaction Ref ID" across multiple rows and if the sum of their "Monetary Amount" is 0, then it should not be displayed in the report.

So in the above example the "Transaction Ref ID" 000015 and 000016 should be hidden as their sum is 0.

Please can you tell me if there is a way to do this in the for loop of the RTF file?

I had seen a similar discussion in the community but it was based on sum of multiple rows, whereas I have to check if the values are similar in multiple columns and then check their sum.

Thomas Dodds · Answer

Why bring the rows over at all?  filter them out at the query level.

Venkateshkamaths · Answer

Hi, Please find the attached layout with the changes. I have added the grouping on the row and the filter on aggregated value of B.MONETARY_AMOUNT . F -> C -> F-> One more F -> F-> Thanks, Kamath

Venkat Thota - BIP · Answer

what is your source data ? while asking question please post your environment details , source system ,bip version etc.