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.