Expressions

[Anonymous]

**Update**

I have this straight table expression ==count({<Date = {[<>NULL]}>}distinct ID)

I really need to understand what is being counted and how would I write the above expression in the script editor, something like this, IF(date <> 'NULL', 1,0) as DateCount? (Where would I add the distinct ID)

[settu_periasamy · Accepted solution]

Ok then, your expression if(date <> 'NULL',1,0) as DateCount looks fine for me.

Try the Expression : Sum(Distinct DateCount)