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:



      Stock movement Reason Code



      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?