Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
How about Left(top_down.expence_category,4)='Income' ?
Jonathan