on 04-24-2023 4:13 AM
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.
User | Count |
---|---|
74 | |
8 | |
8 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.