- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 03:47 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 04:39 AM
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/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-05-2023 04:39 AM
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/