How to Calculate this Grand Total

[TWD]

Ok, this should be my last issue today. lol This is in relation to my other posts. I have a field on my report for grand total. Currently, the control source is this:




=SUM([PAB_AMOUNT]) + [PHR_AMOUNT])


I need to add my new total to this equation, and I don't know how. My new total was created with a conditional expression:

=Sum(IIf([WAGE TYPE] In ("9349"),[PAB_AMOUNT],0))


Is there any way to do this? My only thought is to create a new table field and create an append query with this equation and then add my new table field to the original SUM expression, but I really don't want to go that route.

[pdebaets]

The first SUM has the wrong number of parentheses. Assuming that the SUM is for both fields, you could simply do this to add them:

=SUM([PAB_AMOUNT] + [PHR_AMOUNT]) + Sum(IIf([WAGE TYPE] In ("9349"),[PAB_AMOUNT],0))

[TWD]

The first SUM has the wrong number of parentheses. Assuming that the SUM is for both fields, you could simply do this to add them:

=SUM([PAB_AMOUNT] + [PHR_AMOUNT]) + Sum(IIf([WAGE TYPE] In ("9349"),[PAB_AMOUNT],0))

That worked perfect. Thanks so much!