Case Count Error

[gfisch13]

Hi Everyone - I've got an issue with the pivot table below when trying to calculate the total number of cases and the total number of 'open' cases.  As you can see in the screen shot I have the proper values for the total number of cases.  MY issue is with counting the 'OPEN' cases.   Can someone tell me what I'm doing wrong in this formula, or if there is a better method to use??  Thanks!!

IF(CASE_STATUS='Open',Aggr(DISTINCT, CASE_NUMBER))

[sunny_talwar · Accepted solution]

Try this for open cases:

Count(DISTINCT {<CASE_STATUS = {'Open'}>}CASE_NUMBER)

UPDATE: forgot to add the DISTINCT

[gfisch13]

Thank you!!  Worked perfectly!!  Now I understand what I did wrong!