Null Values Formula Indicators

[MuradServiceNow]

Hi Community, 

I have a formula indicator that computes a percentage (A/B). and collects data for the last 3 months. However I recieve null values but would like to replace it with NA or NAN. Is that possible in ServiceNow ? I tried use this in the formula box:

 IF ([[ B ]] > 0) 

     {A/B}

ELSE 

      {NA}

But it does not work but if NA is replaced with a number its fine but I want NA or NAN to be populated when blank is return by the formula indicator. I want to know is there a method or function in ServiceNow that make null values to NA or NAN. 

[AndersBGS · Accepted solution]

Hi @MuradServiceNow ,

According to my knowledge, there is no possibility to change the score in a formula indicator/automated indicator from a numeric value to a string value. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders