PA - what's wrong with my percentage?

[e_wilber]

I am sure my math is just broken but I can't figure it out.

I have a numerator that shows all active projects that have an active PM that has a total count of 2234 records.

I have a denominator that shows all active projects where the PM is inactive that has a total count of 52.

In my formular indicator as: [[Projects having active PM Numerator]]/[[Projects having inactive PM Denominator]]*100

Why is the widget showing a result of 4296% rather than something less than 100%?

[Unique45]

Hello @e_wilber ,

In your case , Numerator is grater than denominator that's why the the percentage are showing like this.

Add Formula like :

( [[Projects having inactive PM ]] / [[Projects having active PM]] ) * 100 ;

It will give you the correct percentage.

Please mark Correct and Helpful if my answer helps you resolve your issue. Thanks!

[AndersBGS]

Hi @e_wilber ,

You calculation is wrong. What is it that you would like to know/calculate? To have numerator that shows all active projects that have an active PM, and to have a denominator that shows all active projects where the PM is inactive and divide with each other doesn't make any sense calculation wise.

If you would like to find how many projects that have an active PM? if yes, the you should calculate should be:

 [[Projects having active PM Numerator]]/[[All Projects]]*100

If you would like to find how many projects that have an inactive PM? if yes, the you should calculate should be:

[[Projects having inactive PM Denominator]]/[[All Projects]]*100

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders