Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have rather basic skills in set anlysis, so any new expressions are a challenge to me.
Can you please help me write an expression that would do this (I have two options):
1) =sum({<Q={'QN'} , S1 =blank >} Prem)
2) =sum({<Q={'QN'} , Atj_Owner isNotEqualto {'Corporate'} and Atj_Owner isNotEqualto {'FT'} and Atj_Owner isNotEqualto {'KC'}>} Prem)
???
Hope this helps!
=sum({<Q={'QN'} , Atj_Owner={"*"} - {'Corporate','FT','KC'}>} Prem)
Hi,
1) =sum({<Q={'QN'} , S1 = >} Prem)
2) =sum({<Q={'QN'} , Atj_Owner <>{'Corporate'} , Atj_Owner <>{'FT'} , Atj_Owner <>{'KC'}>} Prem)
blank means you dont wont to select nothing in that case just use s1=>,that wont get selected
In the S1 case I would like to select those entries in the table that have no values in S1 column (some of them do and some don't due to concatenation).
It seems that the first option is not working. Can anyone please help me in writing this expression correctly?
2) =sum({<Q={'QN'} , Atj_Owner <>{'Corporate'} , Atj_Owner <>{'FT'} , Atj_Owner <>{'KC'}>} Prem)
Hope this helps!
=sum({<Q={'QN'} , Atj_Owner={"*"} - {'Corporate','FT','KC'}>} Prem)
1) =sum({<Q={'QN'} , S1 ={"=null()"} >} Prem) or maybe
=sum({<Q={'QN'} , S1 ={' '} >} Prem) // 2 simple quotes without space
2) =sum({<Q={'QN'} , Atj_Owner -={'Corporate' , 'FT','KC'}>} Prem) // -= is OK although the expression sais that is wrong
Hi Aizpurietis
We have given the answer. Please mark as correct answer to close the thread if it is working.
Thanks,
Attitude
Hi aiz,
You can use the following
=sum({<Q={'QN'}, Atj_Owner <> {'Corporate','FT','KC'} >} Prem)
Hope it will help you.
Cheers
PRADIP