Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to create a calculated field in the script , based on utilization ,
here is the logic
load
if("SPR_Quantity" > Counter and Counter <> 0 AND Counter >0 ,'Under',
if("SPR_Quantity" = Counter,'None',
if("SPR_Quantity" < Counter or Counter < 0 ,'Over',
if(Counter = 0 ,'All Used')
))) as Usage
I am able put the same logic in the chart but not in the script , I don't see "Over" SPR being filtered out correctly , can someone tell me why ?
Thanks
Attached my document
Aren't you using the SPR.SPR_SUM_QTY field instead of the SPR.SPR_QUANTITY field in your chart expression?
oops !! you are right SPR.SPR_Quantity is the field I have to use.