1 Reply Latest reply: Jul 7, 2011 7:38 AM by Yogesh Bari RSS

    Help with combining existing expression with set analysis

    Chris Hopkins

      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?