Skip to Content
-1
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:

ZAOPRATIO@REQUEST = SUM("ZAOPRATIO@MTHPRODCUSTCURR")

ZAOPRATIO@MTHPRODCUSTCURR = ("ACTUALSREV@MTHPRODCUSTCURR") / ("AOPREV@MTHPRODCUSTCURR")

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.