NULL Handling for Calculated Table Rows or Columns

Null values in most of the calculations in table rows and columns will be handled in the same way that Microsoft Excel handles null values.

When you are creating calculations in your table rows or columns, null values will be ignored, unless they are explicitly included in a calculation. For example, =if (A10 = null,1,2)

Most of the calculations will be handled in the same way that Excel handles these calculations. However, finding the average of two null values will be handled differently. Excel shows a divide by zero error, but SAP Analytics Cloud shows a null value instead.

The following table shows the results of basic mathematical operations as well as the result of calculating an average.