Calculated Measure lock for planning

[daniel_weisblut]

Hi

I am trying to plan the forecast dates (Oct-Dec) By Calculating Quantity * NetPrice
I have the quantities and gross price and discounts in the data

i have this measures and calculate measures in my model as shown attached

Net price is net sales / quantity

In The Planning Table it doesnt let me change the net price the cells are locked

Appreciate your help

[JefB · Accepted solution]

Under table options (3 dots menu) find the option Show/Hide > Show Reasons for unplannable data
and let us know what you see.

Maybe some conditions of inverse formula are not met. Please see help documentation here: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2023.16/en-US/d37a17e4cb7c4a2aabc6825ad142...