Skip to Content
0
Former Member
Jan 16, 2012 at 02:04 PM

Formula - Crystal Report

109 Views

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