187 as a percentage?

Question

issue
water issues - 5 (Apr), 5 (May), 10 (year to date), 16.3% (Year to date %) FORMULA -> (10/62)%
-
-
-
Total - 102 (Apr), 85 (May), 187 (year to date), _______ (year to date%)?????

If the same formula is used for the year to date % in total I get about 300% which is ridiculous! Is there any way, please?

Answer 1

It is unclear what exactly is the formula.

 

187 as a percentage is 18700% which is WORSE than what you expect if you think 300% is bad.

 

I notice you are adding (5+5) = 10 in the first row at the top. You then say the year to date percent is 16.3%

So it appears you are multiplying the total of 10 by 1.6042781....%

 

For the next row, you have 102 + 85 = 187.

Multiplying by 1.6042781% gives 300% as you have suggested.

 

Please repost with the actual formula you are using.

This is the best that can be done with what is given.