I am trying to get number of cases that meet any of the three below conditions
PM Done on time, PM not on time and Open PMs.
In this case two conditions are met but it only returns the first condition that is met, I assume that's how IF statement works. So in the below scenario two conditions are met and I would like to see the case number returned twice, meaning two lines for both PM Done on time and Open PMs conditions. I don't know how to go about it. I have also attached workbook
@Michael Madisha
If each condition can be distinctly defined and you want to calculate the count for each one, it's best to follow what Emery suggested and create a separate field that distinguishes each condition. (Such as PM Done on time or not / Open or Closed PMs)
Then you can count each values too.
