Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
=sum(aggr(count(distinct [Person ID]),Date)) - Counts the Person ID.
Req: I want to create a Text object which shows only the count for Current Year and Month. ( vCurrentMonth & vCurrentYear - Created)
How to accomodate the above requirement in existing syntax for count which is =sum(aggr(count(distinct [Person ID]),Date))
Thanks,
H
Not sure to understand
=sum(aggr(count(distinct if(Month = vCurrentMonth and year = vCurrentYear,[Person ID])),Date))
Not sure to understand
=sum(aggr(count(distinct if(Month = vCurrentMonth and year = vCurrentYear,[Person ID])),Date))
Thanks Eva.