Calculate percentage based on 2 values from same column

[Rahul88]

Hello, 

I would like to create a KPI of the following calculate. 

Total # finished (TRUE) / Total # RUSH (True) + Total # RUSH OVERDUE (TRUE). 

Please see the attached sample excel file.

Thank you,

Kushal

[GaryGiles · Accepted solution]

Try this:

count({$<Finished={1}>} Finished) /(count({$<Primary={'RUSH','RUSH OVERDUE'}>} Primary))