Discussions
Click on this link for the poll.
Highlight result if less than 100% (Case When)
I've got this formula (Text) in a Saved Pricing Search: ROUND(({unitprice}/NULLIF({item.currentstandardcost},0)),4)
Now I want to change the color of the result if it's less than 100%. So i'm trying to create a Case WHEN statement.
The closest I got was the following:
Case WHEN ({unitprice}/NULLIF({item.currentstandardcost},0)*100) < '100'
THEN '<p style="color:#FF0000;"> ROUND(({unitprice}/NULLIF({item.currentstandardcost},0)*100),4) '
ELSE ' ROUND(({unitprice}/NULLIF({item.currentstandardcost},0)*100),4) '
END
But when I use the above formula, I get a weird result. Instead of numbers I get the following:
ROUND(((round(decode(invtitemprice.kpricetype,-1,(select rabsoluteprice from customeritempricing where kitem=invtitemprice.kitem and kcustomer=entity.nkey),invtitemprice.runitprice)*nvl(saleunit.mconversionrate,1),5))/NULLIF((get_total_standard_cost(it_itemlocationmap.kitem, it_itemlocationmap.klocation)),0)*100),4)