Handling empty (NULL) values by formulas

Sometimes it happens that some members of your table do not have any data to display. This can be caused by:

• Specific selection of date interval.
• Application of specific filters combination.
• Missing data in underlying data set.

By default, BellaDati will display empty cell.

Nevertheless, you can use Replace empty value option to define specific numeric value, which will be displayed in the cells.

Following code can be used to catch all empty cells:

if (M_VALUE==NULL){
   ...
}

Using accounting dash ('-')

Use following code to replace empty value will desired symbol (String):

if (M_VALUE==NULL){
   return '-';
}

Next Steps

• Filtering in Formulas
• Calculating Frequencies
• Calculating Percentual Share in Drill-Downs
• Calculating With Members On Defined Level
• Calculating Average Cumulated Values
• Calculating Percentiles and Quantils
• Getting Last Available Value
• Cross-referencing Values from Different Data Set