Hi,
I'm trying to simulate a scenario to see the impact of inflation on price and how it is impacting my sales values.
For example,
Sales = Price * Unit
Price = Price * (1+Growth)
As this is built on new model, so the actual formula would be:
Sales (LC) = Price (LC) * Unit(Qty)
Price (LC) = Price (LC) *(1+Growth (%))
Measures are indicated within brackets and rest of them are account members.
So, when defining the calculation in VDT, I'm not getting an option to read values from Price and Unit as they are on a different measure. Hence, the multiplication is not working as values are on different measure.
I don't see an option for cross lookup of values while writing the formula.
Anyone who has faced this similar kind of issue or knows the workaround on this. Their comments would be deeply appreciated.
Thanks,