Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two Columns - ID and Status
ID
1
2
3
4
..
Status
Running
Pending
Complete
I have to count all the IDs that have more than one Running or Pending or Complete Status
This worked for me
Count(DISTINCT {<ID = {"=Count({<Status = {'Complete'},MonthYear ={[>=$(=MonthName(addmonths(today(),-12)))]}>} Status) > 1"}>} ID)
Count(DISTINCT {<ID = {"=Count({<Status = {'Running', 'Complete', 'Pending'}>} Status) > 1"}, Status = {'Running', 'Complete', 'Pending'}>} ID)
This is still acting up.
For ID A560591, it is counting even though it only has 1 complete and 1 Running. My condition is to count when Count of Running or Complete or Pending is greater than one.
May be this
Count(DISTINCT {<ID = {"=Count({<Status = {'Running'}>} Status) > 1 or Count({<Status = {'Complete'}>} Status) > 1 or Count({<Status = {'Pending'}>} Status) > 1"}, Status = {'Running', 'Complete', 'Pending'}>} ID)