5 Replies Latest reply: Feb 13, 2012 9:36 AM by Chris Hopkins RSS

    Help with expression

    Chris Hopkins

      Hi, i am trying to get an expression to show me TotalValue of some Stock Movement Reason Codes but excludding some descriptions...

       

      My fields are:

       

      StockValue

      Stock movement Reason Code

      Narrative

       

      I want the sum of StockValue for Stock Movement Reason Codes '3,5,16,18' but exclude values with a Narrative of either 'WASTAGE' or 'DAMAGED'

       

      I have the following working for the first part..

       

      sum  ( {<[Stock Movement Reason Code] ={3, 5,16,18}>} StockValue)

       

      but i am unsure on how to add the 2nd part.

       

      Can anyone help please?

       


      Thanks