Null Values Formula Indicators

MuradServiceNow
Tera Contributor

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. 

 

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

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

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

1 REPLY 1

AndersBGS
Tera Patron
Tera Patron

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

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/