Discussion board where members can get started with QlikView.
Can anyone please help me to get the "COST" right ?
Many Thanks In advance
IF LEFT(DESC, 3) = "SRT" THEN (UNITCOST * QTYSHIPPED) * -1
Go to Solution.
use below in script editor
if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES) as COST
hope this helps
Try : if(left(DESC,3)='SRT',(UNITCOST*QTYSHIPPED)*-1,FCSTSALES)
Thank you so much Sunil
Thanks Vincent for your help