In the following formula, I am calculating invoice total {oep65.bigt65} less freight {oep65.bict65} and adding back customer discount {oep65.bdis65} to get the gross invoice less freight for a specified date range.

This part of the formula works fine:

if {oep65.dtin65} >= 1120101 then {oep65.bigt65}-{oep65.bict65}+{oep65.bdis65} else 0

I am required to only count 75% of sales for one of our customers. For everyone else, I count 100%.

I tried to modify the formula as follows:

if {slp05.cnam05} = 'CUSTOMER NAME' and {oep65.dtin65} >= 1120101
then (({oep65.bigt65}-{oep65.bict65}+{oep65.bdis65})*.75) else 0 or
if {oep65.dtin65} >= 1120101 then {oep65.bigt65}-{oep65.bict65}+{oep65.bdis65} else 0

I am getting a boolean on the "0" that I have in bold above. Do you have any suggestions as to how I could modify the formula to calculate the single customer at only 75%?

Thanks,

Karen