3636340 - Minus Operator Does Not Function as Relative Input in Planning-Enabled Cells

• In SAP Analytics Cloud (SAC) planning input-enabled cells, the minus (-) operator does not behave as expected.
• Instead of subtracting a value from the current cell content, using - overwrites the value entirely. In contrast, other operators such as +, *, /, +%, and -% work correctly and apply changes relatively to the existing value.

SAP Analytics Cloud 

1. Open a story using a planning-enabled table with input-ready cells.
2. Select a cell with an existing value (e.g., 300).
3. Enter -100 and press Enter.
4. Observe that the value becomes -100 instead of 200.
5. Now enter +100 and observe the correct relative behavior (result becomes 400).
6. Similarly, test *, /, +%, and -% which all behave as expected.

• This is the expected behavior.
• While `+100` is interpreted as a "relative addition", the `-` operator is interpreted as an absolute overwrite.
• Thus, `-100` sets the value directly to `-100` instead of subtracting from the existing value.

The workarounds are:

• To correctly subtract a value:Use the `-%` operator for percentage-based reduction (e.g., `-10%`). Or, manually calculate the result and input it directly (e.g., input `200` if subtracting 100 from 300).
• If you require the `-` operator to behave similarly to the `+` operator in relative input scenarios, this would be considered a 'feature enhancemen'.

To request the feature to be enhanced, please submit an enhancement request at Customer Influence.. For the detailed information about enhancement process for SAP Analytics Cloud, please refer to 2424376 How do you create an enhancement request and provide feedback for SAP Analytics Cloud?

SAP Analytics Cloud, planning input cell, minus operator, additive input, relative input, overwrite value, - not working, input-enabled cell, % operator, user input behavior, enhancement request , KBA , LOD-ANA-PL-DE , Data Entry and Mass Data Entry , Problem