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

SAP Knowledge Base Article - Public

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

Symptom

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

Environment

SAP Lumira Desktop

Reproducing the Issue

  1. Create a simple Excel File

Capture 1.PNG

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

Capture 2.PNG

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

Capture 3.PNG

  1.  Add this measure to table

 Capture 4.PNG

  1. In row G Lumira returns Empty value.

Cause

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.

Resolution

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}

Keywords

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

Product

SAP Lumira, desktop edition 1.0