4 Replies Latest reply: May 9, 2012 12:24 AM by Aamir Jugnu RSS

How to do IF THEN ELSE

Aamir Jugnu

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