Hello,
I don't know if I'm doing something wrong. I'm looking for a way to repeat the value of a calculated value which I would do via constant selection, e. g.:
Customer Sales Plan Sales Actual Relevant Sales Plan Relevant Total Sales Plan Relevant Constant 4711 500 520 1 500 500 4712 600 0 0 500 4713 200 0 0 500 Total 1100 720 X 500 500
Currently "Sales Plan Relevant Constant" is showing 1100 and not 500 so the value before the calculation even so I'm sure to have done the setup correct.
My question here: Constant selection of a value calculated (either in the query or as calculated KPI) is working? Or is constant selection evaluated before the calculation? I refer to the aggregation steps (Aggregation steps).
Thanks in advance.
Kind Regards,
Hansi