Make text conditional on numeric value

Stimulsoft Reports.JS discussion
Post Reply
crushin
Posts: 6
Joined: Wed Jul 15, 2020 7:18 pm

Make text conditional on numeric value

Post by crushin » Wed Jul 15, 2020 7:25 pm

Hi, so I want to display text depending on the value in my JSON. I assumed I would do a conditional and use highlight text but that did not work it still only displayed the number value.

What I would like to display is
if value is between 90 -100 display 'EXCELLENT'
if value is between 75 -89 display 'GOOD'
if value is between 55 -74 display 'FAIR'
if value is <= 54 display 'POOR'

How do I make this happen?

Thanks.
Lech Kulikowski
Posts: 3239
Joined: Tue Mar 20, 2018 5:34 am

Re: Make text conditional on numeric value

Post by Lech Kulikowski » Wed Jul 15, 2020 9:10 pm

Hello,

You can use Switch or IIF functions.

Thank you.
Post Reply