null values in count

[Seven7]

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 ?

[JuanGerardo]

Hi @Seven7 , you can try this:

Count({(<condition1> + <condition2>) * <phones = {'home', 'work', 'cell'}>} distinct ID)

JG

[Seven7]

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 ...

[JuanGerardo · Accepted solution]

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