Hiding multipe rows in a for loop

User_Q7YHM

Summary

Hiding multipe rows in a for loop

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.

Venkat Thota - BIP

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

Thomas Dodds

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

Venkateshkamaths

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 -><?for-each-group:current-group();./B.TRAN_REF_ID?>
C -><?if:sum(current-group()/B.MONETARY_AMOUNT)!=0?>

F-><?for-each:current-group()?>

One more

F -><?for-each-group:current-group();./B.TRAN_REF_ID?>

F-><?for-each:current-group()[sum(B.MONETARY_AMOUNT)!=0]?>

Thanks,

Kamath