Forum Discussion
Solved
Percentage Retention
Hi, I need help please, I'm trying to get "Result expected" calculated from the table as shown below, ei; Year 2023 Column E / Year 2019 Column A = 101.27%:
| Year | A | B | C | D | E | F | G | H | I | J | K | L | M |
| 2023 | 237 | 272 | 252 | 227 | 239 | 191 | 205 | 207 | 194 | 161 | 133 | 133 | 99 |
| 2022 | 280 | 262 | 231 | 236 | 214 | 208 | 221 | 200 | 171 | 144 | 139 | 105 | 98 |
| 2021 | 264 | 237 | 235 | 212 | 208 | 222 | 201 | 189 | 154 | 161 | 116 | 109 | 112 |
| 2020 | 235 | 241 | 203 | 216 | 222 | 208 | 189 | 156 | 168 | 126 | 117 | 121 | 87 |
| 2019 | 236 | 191 | 204 | 219 | 212 | 194 | 165 | 168 | 135 | 126 | 129 | 92 | 66 |
| 2023E/2019A | 2023G/2019E | 2023M/2019I | 2012M/2019P | ||||||||||
| Result expected | 101.27% | 96.70% | 73.33% | 76.74% |
Many thanks. Rosario.
Your expected results are inconsistent but here is one version
2 Replies
Your expected results are inconsistent but here is one version
Hi, Thanks for your support, it helps for the first result. I know there are inconsistencies, and it was we really are after. You help gave me an idea on how to get the other reuslts. I will try and see if it works. Thank You. Rosario.
