1 Reply Latest reply: Jan 14, 2013 7:16 AM by Jonathan Brough RSS

    Script Issues with multiple fields

      Hi, I am after some advice on pulling through some information. I currently have the following definition in my expressions:

       

      Sum

      (if (top_down.expence_category <> 'INCOME',top_down.direct))+Sum (if (top_down.expence_category <> 'INCOME',top_down.indirect))+Sum (if (top_down.expence_category <> 'INCOME',top_down.overhead))

       

      However where i have <> 'INCOME' I need multiple values in here i.e. 'INCOME', 'INCOMEA', 'INCOMEC'

      It doesnt appear NOT LIKE or DOES NOT CONTAIN is an option.

       

      Could someone please advise on best way to do this??