Suggestions on how to format calculation (nested aggregation error)

[MCHK]

I am trying to use the below calculation (to obtain a percentage).  I am geting the nested aggregation error.  Is there another way to format this calculation so that I can avoid this?

=COUNT((PGS_BFOngoing)+COUNT(PGS_NewOpen)-count(PGS_ActivePrg)-count(PGS_ActiveRes))/((COUNT(PGS_BFOngoing) + COUNT(PGS_NewOpen))

Thank you

[justISO · Accepted solution]

Hi, I believe you want to sum some counts (not count counts as you doing now). How about just like this:

(COUNT(PGS_BFOngoing) + COUNT(PGS_NewOpen) - COUNT(PGS_ActivePrg) - COUNT(PGS_ActiveRes)) / (COUNT(PGS_BFOngoing) + COUNT(PGS_NewOpen))

[MCHK]

Thank you - Perfect!  You are correct and this works.