Inverse Formula and Cell Fixing 

Technical Data

Function Is	New
In Release	Software Component ●      SAP NetWeaver ●      Release: Enhancement Package 1 for 7.0 ●      Support Package Stack 06
Country Setting	Valid for all countries

Use

To be able to change values for calculated key figures (like Average Price as a quotient of Amount and Quantity) in manual planning, you can make formulas input ready. The input-ready formula becomes the carrier of a formula group. In our example, the group is made up of quotient Average Price and the two operands Amount and Quantity. A rule needs to be defined in the form of an inverse formula for every input-ready formula operand. This rule defines how the system calculates back to this operand whenever the value for the Average Price is changed.

For more information about design time, see Input-Ready Query and Defining Inverse Formulas.

For more information about runtime, see Performing Manual Planning (design time) and Inverse Formulas (runtime).

When working with input-ready calculated key figures, calculating inverse formulas or using disaggregation settings, it can be helpful to fix cells. Note though that this function is only available in Web Applications created with BEx Web Application Designer (WAD).

More information: Inverse Formulas and Cell Fixing.