Hello all,
I have report a for Sales by Sales Employees. The Sales Column is less VAT and I have used the formula (OINV.DocTotal/1.16) to get sales figure. NB. VAT = 16%
However, I want to come up with a conditional formula to exclude invoices with zero rated items from being divided by 1.16. The logic should be as below:
IF INV1.VATGROUP='O2' THEN OINV.DOCTOTAL
ELSE IF
INV1.VATGROUP='01' THEN OINV.DOCTOTAL/1.16
Kindly assist me to achieve the above using the correct Crystal syntax. Thank you
Regards,
Henry