2 Replies Latest reply: Sep 19, 2011 9:29 AM by Chris Hopkins RSS

    Help writing expression

    Chris Hopkins

      Hi all,


      I am trying to write an expression to give me WASTE as a % of SALES.


      The calculation is:


      StockValue / SalesValue

      but i need it to exclude any selections made from the field [Stock Reason], so this is what i have so far which seems to work


      Sum(StockValue)/Sum({$<[Stock Reason] = >}SalesValue)


      But i also need to exclude any sales from DEPT = U .


      This is where i am having problems, can anyone help me to write the expression to do all of the above?




      StockValue needs to be divided by SalesValue excluding Dept U and ignoring selections from StockReason


      Any help woulf be appreciated..