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?

       

      so..

       

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

       

      Any help woulf be appreciated..

       

      Thanks