Skip to Content
Apr 24 at 03:13 AM

Key Figure for ratio calculation

63 Views Last edit Apr 24 at 11:06 AM 3 rev

Hello Expert,

i have an question regarding key figure calculation for defining a ratio between 2 different KF.

i am trying to calculate the ratio between actuals qty rev and aop rev to understand how revenues are going from the plan.

i created the following calculated key figure with a formula:



however the ratio i obtain it is not correct. for example, when AOPRev = 420k and Actuals Rev = 474k i get a ratio of 166% (instead of 112%)

Does the formula need some additional steps?

thank you for your time.