IF statements in a Variable on a report.

[gregory.west]

I have a varaible basically I want it to say OK if the markup is over 40% for most items, but for items under $25 I want the mark up to be OK if it is over 80%.    This is what I am trying to get to work, but I am getting an error at the AND operator:

IF($F{lastcost} >= ($F{sellprice} /1.40),"Low Sell",IF(($F{lastcost} >= ($F{sellprice} / 1.80)) AND ($F{lastcost} < 25),"Low Sell","OK"))

 

I expect my problem is the use of AND.   Pretty new to Jasper, so could be just about anything.

[ernst_2]

try:

($F{lastcost} >= ($F{sellprice} /1.40) ? "Low Sell" : ($F{lastcost} >= ($F{sellprice} / 1.80) && ($F{lastcost} < 25) ? "Low Sell" : "OK"))