Any Sample workbook and your expected output ?
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:
- number of possible causes (where I am going wrong each time?)
- solutions to each cause
Percentage calculation consists of two numbers i.e Numerator and Denominator. You just adding the values of coverage.
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.
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.
1 of 1 people found this helpful
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 ?
Thanks Chris and Ombir,
That has solved my question.