Help with combining existing expression with set analysis

[hopkinsc]

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?

[#2]

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")