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

[JefB]

Have you tried the inverseif() formula?