Hi Team,
When I try to count # of records based on a certain criteria, I am only seeing some of data:
FORMULA: IF [Action Required] = 'Y' then COUNTD([Number of Records]) END
In the below example only counts 3 records but on the right I see a lot more than that
Any thoughts as to why?
Best Regards,
Brad Smith
Hello Bradley,
I believe the problem is because you are counting the distinct values of Number of record "COUNTD([Number of Records])" and this is a calculated field made up of '1'.
What field are you trying to count the distinct values of?
Hi Brett,
Thank You
I am trying to count Associates whose Action Required Field is Y so the Leaders know how many discussion they need to have with there team.
It kinda of works now with the new formula: IF [Action Required] = 'Y' then COUNTD([Associate]) END but for some reason only shows 1 record.
Best Regards,
Brad Smith
Oh I can see three rows of data in my version:
Sorry my filters were messed up, but why when I select the first row in the Leader View does it only show 1 record and not all 13
