Creating reports and dashboards | Stimulsoft community forum

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))?

Hello,

You can use the SumIf() function.

Thank you.

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

Hello,

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

Thank you.