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))?
Reusing the same table more than once
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Reusing the same table more than once
Hello,
You can use the SumIf() function.
Thank you.
You can use the SumIf() function.
Thank you.
Re: Reusing the same table more than once
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
-
- Posts: 6272
- Joined: Tue Mar 20, 2018 5:34 am
Re: Reusing the same table more than once
Hello,
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data that reproduces the issue for analysis.
Thank you.