Skip to Content
0
Former Member
Aug 04, 2006 at 02:33 PM

Use Calculate Single Values in calculations

26 Views

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