We have created a cash sales report which groups the sales based on the accounts it is posting this against.

This report was working fine until there was one change which was based on the Tax categories.

My variable calculation is as follows:

=IIF([ARInvoice.TaxZoneID]='DOMESTIC', ROUND(SUM(IIf([ARTran.AccountID]='41005', [ARTran.CuryTranAmt], 0))/1.1,0), ROUND(SUM(IIf( [ARTran.AccountID]='41005', [ARTran.CuryTranAmt], 0)),0))

AS water is GST Free it is against the Tax category as below. However as soon as this category is entered my numbers are doubling up.

I am not able to figure out why this would be the case, as all the other figures are found to be right.

Would this be really a Report issue or a Adjustment somewhere on the Tax Zone/ category etc.