We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Formula Indicator to return string value

venori26
Tera Contributor

Hello team,

 

I am trying to use formula indicator to return a string value based on a condition something like:

 

If ([[indicator1]]/[[indicator2]] < 5) {"good"} else {"bad"}

 

Apparently formula indicator returns only numeric values.

 

Is there any work around?

 

Thanks in advance

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron

Hi @venori26 ,

 

This is not how  formula indicators work. Formula indicators is for mathematical calculation and will return a score of some sort - not a string. 

 

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

5 REPLIES 5

AndersBGS
Tera Patron

Hi @venori26 ,

 

This is not how  formula indicators work. Formula indicators is for mathematical calculation and will return a score of some sort - not a string. 

 

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/