Empty survey repsonses for the numeric scale is storing -1 as the actual value

[sanga2]

Hi All,

We have a numeric scale survey in place, and whenever the response is empty for the survey, when we create a report on it, the actual value is coming as -1.

I have read somewhere that this is the default behaviour of the servicenow for numeric fields to store value of -1 if the response is empty. This is a placeholder or indicator that no response is given to that particular question. Can any one confirm this OOB behavior and is there a way we can modify to show it as empty instead of -1?

[AnveshKumar M · Accepted solution]

Hi @sanga2 

Yes its OOB behavior and there is OOB way to change the default value. The work around is create a After Insert Business Rule on asmt_metric_result table and set the conditions to match the question actual value is -1, then set the value to your preferred default value.

Please mark my answer helpful and accept as solution if it helped you 👍✔️

[sanga2]

Hi Anvesh, thank you for confirming. How does creating a after insert BR will impact the reporting? I mean what if someone responds to the survey at a later time? 

Also, can you help with the knowledge article or servicenow doc relating to this OOB behaviour?

[AnveshKumar M]

@sanga2 my intention is to set the value once the user is responded.