Reusing the same table more than once

[CCS]

Hi

I have a Master Detail relation. For each record in Master, I will need to print 2 Calculated Columns from Detail.

The first calc column is accumulating an Amount field based on a condition while the other calc column is doing the same but based on a different condition. Example, amount for Allowances and Reimbursements.

Is this possible using SUM(IIF(xx=yy,aa,0))?

[Lech Kulikowski]

Hello,

You can use the SumIf() function.

Thank you.

[CCS]

Thanks. I tried that and it is working for one condition. But for another Calc Column where the condition is for the other case, the values does not seem to work. Keep getting 0 returned. Have to try it more and see if I did something wrong

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.