Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have this expression :
Count({$<condition1>+<condition2>} distinct(ID)
I want to add a condition based on 3 fields exemple phones(home,work,cell) ===> at less one of them is Not Null
how can i do it ?
To add a condition to check for any not null value you can use the asterisk, like this:
Count({$<condition1 on StartDate>+<condition2 on EndDate> + PhoneNumber={"*"}} distinct(_ReferenceID)
PD.- I suposse the <> you are using are not different set expressions, just conditions in the same set, as different sets are delimited by <>.
JG
Hi @Seven7 , you can try this:
Count({(<condition1> + <condition2>) * <phones = {'home', 'work', 'cell'}>} distinct ID)
JG
Tables :
Transaction (_ReferenceID, StartDate, EndDate)
CustomerPhones(_ReferenceID, CellPhone, HomePhone, BusinessPhone)
Count({$<condition1 on StartDate>+<condition2 on EndDate>} distinct(_ReferenceID)
this count work for me !, now i want to count only _ReferenceID who has at less one phone number NOT NULL ...
To add a condition to check for any not null value you can use the asterisk, like this:
Count({$<condition1 on StartDate>+<condition2 on EndDate> + PhoneNumber={"*"}} distinct(_ReferenceID)
PD.- I suposse the <> you are using are not different set expressions, just conditions in the same set, as different sets are delimited by <>.
JG