3664863 - Issue with entering the scaled value in SAP Analytics Cloud, add-in for Microsoft Office

• In the SAP Analytics Cloud Story, the "in thousands" number format is applied for measures like unweighted quantity or revenue.
• In the SAP Analytics Cloud Excel Add-In, the same "in thousands" number format is applied, and the view displays correctly with the scale. However, when entering values, the system interprets the input as the real, unscaled value instead of the scaled value.
• For example, entering "20" in a cell is interpreted as "20" instead of "20 thousand".
• The issue persists even after applying the number format.
• The formula bar displays the real, unscaled value, while the cell displays the scaled value.

SAP Analytics Cloud, add-in for Microsoft Office

1. Open the SAP Analytics Cloud Excel Add-In file.
2. Enter a value, such as "20", in a cell.
3. Observe that the system displays "0k" in the cell and "20" in the formula bar.
4. Enter a value, such as "2000".
5. Observe that the system displays "2k" in the cell and "2000" in the formula bar.

The behavior observed is expected and designed intentionally. Specifically, the data entry in the cell always retains the real, unscaled value, which you can view in the formula bar. While the scaled value is displayed in the cell, the underlying value is different. 

In the SAC story in the web browser, there are 2 change events of a cell:  single-click and double-click. So the SAC planning team can develop different behaviors for these 2 events: the scaled value is entered with the single-click and the real, unscaled value is entered with the double-click.

However, the Excel eventing does not offer this distinction. Instead, there is only one change event, and the SAC Add-in team has opted to process the real value in such cases. 

If you want to enter the scaled value in SAC Add-in, a possible workaround would be to create a scenario using the SAPSetData formulas.

You can also consider creating an enhancement request as per KBA 0002424376 for the new feature to support entering scaled values in the SAC Add-in.

SAP Analytics Cloud, SAC add-in, addin, add in, Excel Add-In, number format, in thousands, scaled value, unscaled value, data entry, SAPSetData formula, enhancement request, SAC planning, formula bar, scaled input, scaling, scales, millions, million, M, thousands, number format, formatting, styling tab, style , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem