How to do IF THEN ELSE

[#1]

Hello Everybody,

Can anyone please help me to get the "COST" right ?

Many Thanks In advance

IF LEFT(DESC, 3) = "SRT" THEN (UNITCOST * QTYSHIPPED) * -1

ELSE FCSTSALES

AS COST;

Kind Regards

Aamir

[vincent_ardiet]

Hi,

Try : if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES)

Regards,

Vincent

[SunilChauhan · Accepted solution]

use below in script editor

if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES)  as COST  

hope this helps

[#4]

Thank you so much Sunil

Aamir

[#5]

Thanks Vincent for your help