Hi,
I would like to know the if the values(displayed) by using 'Calculate Single Values as - Normalization to Result' for further calculations.
As these are only displayed, I am not sure if they can be used in calculations. Is there any other way to achieve this.
For example:
Location - Customer - Sales - XSales(Norm to result) - Price - (XSales*Qty)
L- -C -- S -- XS --P --(XS*P)
L1- C1 -- 10 -- 25% - 4 -- 100
L1- C2 -- 20 -- 50% - 2 -- 100
L1- C3 -- 10 -- 25% - 3 -- 75
-
..........40 -- ....... -- 275
-
Can I get (XS*P) value in query, is there any way to get using any formula variables or user exits.
Let me know if its not clear.
Thanks,
Ace