=Round(DSum("[Rebate]","QuarterWorkingDetail","[Quarter Year]= ""32016""")-([Q3Payment]+[Q3Adjustment]),2)
For now, I have my calculation like that. However, problem with this calculation is if I don't have "[Quarter Year]= ""32016""" data it will return nothing in the text box. So In order to get 0 for null values, I used IIF function for this calculation.
=IIf(Round(DSum("[Rebate]","QuarterWorkingDetail","[Quarter Year]= ""32016""")-([Q3Payment]+[Q3Adjustment]),2),IIf(IsNull(Round(DSum("[Rebate]","QuarterWorkingDetail","[Quarter Year]= ""42016""")-([Q4Payment]+[Q4Adjustment]),2)),0))
The thing is I am getting 0, even though I have data in 32016. Is there any way to solve this problem? Is my calculation wrong?
Thank you