Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to do a count of users who currently have a termed date in our system. I have the following fields, [Full Name] and [Date Termed]. I just need the number of users where the [Date Termed] is not null.
write this syntax in expression
if([Date Termed]<>'',count([Full Name]))
************************************************
or in script writ this
load
[Full Name]
count(if([Date Termed]<>'',[Full Name])) as countFullname
from table
group by [Full Name];
count([Date Termed])
count([Date Termed])
write this syntax in expression
if([Date Termed]<>'',count([Full Name]))
************************************************
or in script writ this
load
[Full Name]
count(if([Date Termed]<>'',[Full Name])) as countFullname
from table
group by [Full Name];
now what if i wanted to do it for after a specific date, say 01-01-2014? I can't get the syntax right for the where clause.
try this
if(date([Date Termed],'DD-MM-YYYY')>'01-01-2014',COUNT([Full Name]))