6 Replies Latest reply on Nov 18, 2018 2:10 AM by Mohamed Hersi

# Percentages Going Crazely and Unexpectedly High

Hi All,

I have been experiencing this problem for sometime now. Percentage values shooting up the sky. Any idea of what could be done to fix this?

Below is a screen shot of the problem:

Regards

Mohamed

• ###### 1. Re: Percentages Going Crazely and Unexpectedly High

Any Sample workbook and your expected output ?

• ###### 2. Re: Percentages Going Crazely and Unexpectedly High

Dear Ombir,

I have attached the sample workbook. As you can see the Coverage % is too high and and wrong. I have had  this kind of problem many times.

Also, if possible, in addition to helping me with this, please share your suggestions on:

1. number of possible causes (where I am going wrong each time?)
2. solutions to each cause

Regards

Mohamed

• ###### 3. Re: Percentages Going Crazely and Unexpectedly High

Percentage calculation consists of two numbers i.e Numerator and Denominator. You just adding the values of coverage.

For example:

In Gabon for 2004 its just adding these numbers for various vaccines as per your filter selection which equals 214.

 43 54 37 15 27 38

You formatted SUM(Coverage) to % which multiplies 214 by 100 and adding a % sign.

You need to update your calculation for percentage.

• ###### 4. Re: Percentages Going Crazely and Unexpectedly High

Hi

you are displaying sum(coverage) values in percentage format that is why it is showing up high values. You can use table calculation to display percentage of total or percentage difference.

• ###### 5. Re: Percentages Going Crazely and Unexpectedly High

What does 214 in Gabon in 2004 mean ?

Or is Coverage supposed to be a percentage and you want the average of all the Coverage values in 2004 ?

It's great that you know it's wrong because you're sense-checking the data, but from the other replies posted you can see that there needs to be some more understanding around what the data is trying to show.

It **might** be that each value (eg 43) means 43%, so should really be .43 (just divide by 100), then change SUM(coverage) to AVG(coverage), but is that what you're trying to do though ?

1 of 1 people found this helpful
• ###### 6. Re: Percentages Going Crazely and Unexpectedly High

Thanks Chris and Ombir,

That has solved my question.