SAP Analytics Cloud for planning - Inverse Formula Behaviour

[guenay]

Hi friends,

I'm currently utilizing an inverse formula to determine the sales price based on gross sales and sales volume.

When I adjust the price, the gross sales are appropriately recalculated. This works well.

Similarly, when I modify the gross sales, the price adjusts accordingly. This is also functioning correctly.

However, when I alter the sales volume, it adjusts the price instead of the desired adjustment in gross sales. Is there a method to achieve this without resorting to the "Lock Cell" feature, perhaps through a default setting?

 Kind regards,

Ismail 

[luigi_simoncini]

Hi Ismael, you probably want to define Gross Sales (not Price) as a formula with inverses for Price and Volume in that order Hope this helps

[N1kh1l · Accepted solution]

@guenay 

Inverse is triggered according to the priority (order in which its written) and whether one of the variables are unbooked. But if you adjust one of the variables of the primary formula, primary formula will trigger first.

Price=Gross Sales/Sales Volume, If you adjust the volume it will calculate new price as that's what is your main formula . Unless you lock the Price, any adjustment in GS or SV will first affect price (primary formula)

Inverse will trigger if you change price, in this case Gross Sales will calculate and if you change price and GS Volume will get calculated.

Nikhil

[guenay · Accepted solution]

So the conclusion is without locking the price before changing Gross Sales we can't prevent it from adjusting.

[JefB]

Have you tried the inverseif() formula?