2130894 - NDIV0 Function in Key Figure Formulas

SAP Knowledge Base Article - Public

# 2130894- NDIV0 Function in Key Figure Formulas

### Symptom

You want to know why the NDIV0 function is used while creating a Key Figure.

### Reproducing the Issue

1. Go to the Business Analytics work center.
2. Go to the Design Key Figures view.
3. Search for any Key Figure which uses the NDIV0 function, say for example: Average Handle Time.
4. Click on the Documentation.
5. Find that the function NDIV0 ﻿is used in the ﻿Formula.

### Cause

The NDIV0 function is used to avoid the error caused by division by 0. If you happened to use in your own key Figure an expression of the form DIV("EXP1","EXP2") where one of the values of "EXP2" happens to be 0 then this would raise an error. As a consequence, subtotals on this column would also throw an error.

By using the function the system will return 0 instead of an error.

For example, the formula for Average Handle Time is:

NDIV0(DIV("Ticket Handling Time (Secs)", "Counter"))

if the values for "Ticket Handling Time (Secs)" and  "Counter" are 4 and 0 respectively, then if NDIV0 function is not part of the formula then as per the formula, 4 divided by 0 will result in an error.

### Resolution

Use NDIV0 ﻿to prevent the division by 0.

For Average Handle Time: NDIV0(DIV("Ticket Handling Time (Secs)", "Counter")) if the values are applied then, NDIV0(DIV("4", "0")) will result in 0 instead of an error.

This way subtotals (or any other calculation based on this formula) will not give an error.

### Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

### Product

SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711 ; SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711