1958548 - In SAP BusinessObjects Lumira NULL values in calculations returns "NULL" instead of 0

When creating a calculation with Lumira Desktop/Discovery where one value is NULL Lumira returns NULL.

SAP Lumira Desktop

1. Create a simple Excel File

2. Create a new DataSet with this Excel File
3. Add "Product", "Ship" and "Plan" to ATTIBUTES

4. Create a new measure with this aggregation {Ship} + {Plan}

5.  Add this measure to table

6. In row G Lumira returns Empty value.

This behaviour is due to Lumira not automatically converting NULL values to 0. This is because NULL is not necessarily equivilent to 0. For example if you have survey data that has an optional field for salary, a person could choose not to enter it. This does not mean the person had 0 salary, though it could, it just means they don't want to answer.

A calculation can be created to convert NULL values to 0 values. For the above example it would look like the following:

if IsNull({Ship}) then {Plan} else {Ship} + {Plan}

measure NULL + Value, empty cell, empty value, aggregation with empty value, calculation , KBA , BI-LUM-DIS , Lumira Desktop/Discovery , Problem