Skip to Content
0
Jan 14, 2023 at 09:28 AM

How to write a custom calculation in Value Driver Tree (VDT) in new model in SAC?

103 Views

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,