hi all, I got a question about count. i want to count how many of this data got Not Stated in there but somehow I can't figure it out how to do it yet.
here is the eg:
Data Item 1 contain: On Plan, Not Stated
Data Item 2 contain: In Trouble, Not Stated
Data Item 3 contain: In Trouble, Not Stated
result I want it count how many Not Stated in those 3 Data Items
Cheer
Thank you
Here are two ways to achieve this:
- COUNT(CASE WHEN [Stated Status] = 'Not Stated' THEN [Stated Status] else null)
- TOTAL(CASE WHEN [Stated Status] = 'Not Stated' THEN 1 ELSE 0)