6 Replies Latest reply: Mar 9, 2011 1:54 AM by Yogesh Bari RSS

    Expression Logic Question

    HeyZeusChris

      =sum({$<Type = {'New'}>} Amount)

       

      As I understand it this will sum Amount as long as the Type is equal to 'New'. How do you change this formula so that it sums Amount if type is NOT equal to new.

       

      I tried

       

      =sum({$<Type <> {'New'}>} Amount) but the use of the <> does not seem to work.

       

      Thanks for your help.