Entire Formula Indicator data count shows 'Nil' or 'Empty' when one of the indicator value is 'Nil' or 'Empty' - Support and Troubleshooting

Entire Formula Indicator data count shows 'Nil' or 'Empty' when one of the indicator value is 'Nil' or 'Empty' Issue Entire formula indicator value shows 'Nil' if one of the indicator value is 'Nil'. The formula indicator based on Sum operator

STEPS TO REPRODUCE:

1. Create a formula indicator based on two separate indicators as shown above in the screenshot.

2. Under 'formula' -- Add these two indicators with sum condition

3. Upon running daily data collection jobs, if one indicator(Ind1) doesn't collected any data and other indicator(Ind2) collected with data.

4. Now, the formula indicator will be not showing any data for the month of May and August, 2020.

Release All Releases

Resolution To avoid this issue,

-- While creating an indicator, We need to set the field 'Value when Nil' to 0 and it will resolve the issue.

-- To create an automated indicator,

Please refer to the product documentation.

Create an Automated Indicator

Please refer to the below screenshot.

Related Links Please refer to the below KB article for additional information:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0854555