Solution : https://service.sap.com/sap/support/notes/794006 (SAP Service marketplace login required)
Summary :
SAP Note Explanation: Users have reported discrepancies in query outputs where expected null values are displaying as zero. This arises from mathematical definitions in OLAP processing, where nulls were typically equated to zero. This default behavior aligns with common expectations unless performing operations like multiplication or division with a base key figure and a constant, which, contrary to expectations, results in zero rather than null. To address these concerns, calculations now more accurately differentiate null values with specific rules laid out for operations involving nulls, zeros, and valid values, enhancing formula precision and aligning output closer to user intentions. Users accustomed to seeing zeros can modify formulas to maintain this display.
Key words :
basic key figure, -digit operators o1, correct null values, key figure, -digit operators, null values, existing values, system displays, empty cell, terms query
Related Notes :
| 1512632 | Sparse data and restricted key figures in WebI reports |
| 1296360 | Unit or currency is not displayed |
| 1291158 | Exception aggregation and mixed units or currencies |
| 1094885 | Error message BRAIN A258 with addition of null value |
| 995494 | Null value with operators %A and %_Aa |
| 994194 | Formulas with Boolean operators display only zeros |
| 984133 | The operators NDIV0 and NOERR delete unit and currency |
| 763338 | SAPBWNews BW Support Package 11 NW'04 stack 11 RIN |
| 723262 | SAPBWNews BW 3.1 SP Content 20 |
| 723257 | SAPBWNews BW 3.0B Support Package 26 |