topic Re: If Statement using Variables for Colors in App Development

If Statement using Variables for Colors

mhorsfall — Thu, 12 Oct 2023 19:03:35 GMT

I have an if statement:

IF($(vForecastVarianceMTD) < 0,
rgb(255, 0, 0),
rgb(0, 153, 0))

The goal here is to make red if negative, and green if >= 0. I am currently getting the error: Error in expression: ')' expected. Not sure where the ')' is expected, but when I look at the sample script below, it outputs the full expression for the variable but it does not show the < 0, prior to showing the rgb part. When I put just the variable in a KPI it shows the value that I expect it to show. Any thoughts from the community?

Re: If Statement using Variables for Colors

Lisa_P — Thu, 12 Oct 2023 23:44:20 GMT

What is inside your vForecastVarianceMTD variable and where are you trying to apply this ?

Re: If Statement using Variables for Colors

anat — Fri, 13 Oct 2023 02:47:28 GMT

seems your logic looks good,

can you try by placing the actual expression in if statement.

IF(sum(sales) < 0,rgb(255, 0, 0),rgb(0, 153, 0))

Re: If Statement using Variables for Colors

ajaykakkar93 — Fri, 13 Oct 2023 02:57:49 GMT

Hi,
Please check the value of $(DynamicTableName), what is the output ,
below is also another way to add color using #

IF($(DynamicTableName) < 0,
'#ff0000',
'#009900'
)

Re: If Statement using Variables for Colors

mhorsfall — Fri, 13 Oct 2023 14:41:47 GMT

There was an extra parenthesis in the statement for the variable -- when I put that expression on its own there was no issue because nothing else was coming after, which is why it allowed an output I presume, but then when put in variable form it could not interact with the rest of the expression because of that extra parentheses. Was able to resolve this by putting the entire expression in the if statement and troubleshooting that way.

Re: If Statement using Variables for Colors

mhorsfall — Fri, 13 Oct 2023 14:41:47 GMT