Do you have an S- or P- account?

If so, you need SAP Universal ID. In a few months, SAP Universal ID will be the only option to login to SAP Community. Without it, you will lose your content and badges. If you have multiple accounts, use the Consolidation Tool to merge your content.

Apr 24 at 03:13 AM
# Key Figure for ratio calculation

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.