Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i ahve the following expression in my chart:
sum(if(Narrative<>'WASTAGE'and Narrative<>'DAMAGED',StockValue))
I need to add in the following set analysis
sum({< Cal_Date=,Cal_Week=,Cal_Year=,Cal_DayCount={">$(=max(Cal_DayCount)-1) <=$(=max(Cal_DayCount)-0)"}>} "StockValue")
but i am unsure on how to do it..
Can someone tell me how to make it a single set analysis expression please?
May try this expression :
sum({< Cal_Date=,Cal_Week=,Cal_Year=,Cal_DayCount={">$(=max(Cal_DayCount)-1) <=$(=max(Cal_DayCount)-0)"} , Narrative -= {'WASTAGE','DAMAGED'} >} "StockValue")