15 Replies Latest reply: Sep 14, 2010 11:42 AM by Miguel Angel Baeyens de Arce RSS

    Help with Set Analysis Expression...

    Chris Hopkins

      Hi, i am trying to write an expression to bring back total SalesValue - Total Voids for a transaction.

      I know how to calculate total sales value - Sum(SalesValue), but this also includes VOID values. A void is obviously not part of the transaction value, so i need to deduct this off.

      my fields are

      SalesValue (the price of each item)

      LineType (specifies if the transaction line is a SALE/ VOID/REFUND etc)

      I have tried the following....

      Sum({$<LineType ='V'>}SalesValue)

      but this just displays the void value.

      Can anyone help?