Formula indicator returns nil value when there is no data, can we display '0' instead of no score?

[Banu1]

Hi,

Formula Indicators returns No Score when there is no data to display. Where as we have something called 'value when nil' indicator to display value eg as '0'. But when it comes to Formula indicator there is no option to display '0' instead of empty score. Any idea on how to make it as '0'? Indicators used in formula is having the value when nil as '0' but still this is not giving me data as '0' in the scorecard.

Thank You!

Banu

[Ajaykumar1]

Hi Banu,

Right click on header > Configure > Form Layout > Search for "value when nil" > pull it in selected List > save

You will see it on your Formula Indicator form.

Mark if Correct/Helpful

Regards,
Ajay

[Banu1]

Hi Ajay,

Its not working. I tried by giving 0 & in scorecard it is not reflected.

Thank You!

Banu

[Adam Stout]

Are you trying to divide by zero?  If that happens, you will get null (since that isn't valid).  You have to handle the division by zero in your formula.  Take a look at this article for some more explanation and examples:

https://community.servicenow.com/community?id=community_blog&sys_id=1f0d2ea5dbd0dbc01dcaf3231f961947

[Banu1]

Yes Adam, For some of my score the division is by '0'(indicator used in formula returns '0' for division) for which the value returns nil. 

Please help to fix this issue, as am stuck & need to fix this as soon as possible, so that this scorecard go live 😞