Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
use below in script editor
if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES) as COST
hope this helps
Hi,
Try : if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES)
Regards,
Vincent
use below in script editor
if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES) as COST
hope this helps
Thank you so much Sunil
Aamir
Thanks Vincent for your help