topic If condition with range in App Development

If condition with range

Saritha077 — Tue, 03 Dec 2024 09:47:11 GMT

Hi All,
I am creating table with multiple fields i.e. dimensions and expressions
I want give conditional background color for measure, my measure is ratio

ratio values are like -5%,0%,3%,8%,10%.

my color condition is that like below :

If(ratio < 3%, green(),

If(ratio < 3% to 5% , yellow(),

If(ratio > 5%, red()))

I am giving condition here

If i use above condition for color control it is not giving correct colors.

Please help me to get correct colors.

thanks in advance.

regards,

Saritha.

Re: If condition with range

sbaro_bd — Tue, 03 Dec 2024 10:27:38 GMT

Hello @Saritha077 ,

Modify your expression like this :

If(ratio <= 0.03, green(),

If(ratio <= 0.05, yellow(),

If(ratio > 0.05, red()))

Regards.

Re: If condition with range

AshutoshBhumkar — Tue, 03 Dec 2024 10:33:42 GMT

Hi Saritha,

Use below expression:

If(ratio <= 0.03, green(),

If(ratio <= 0.05, yellow(),

If(ratio > 0.05, red()))

OR use master measure and set colors for threshold for reusability.

Thanks,

Ashutosh