Formula to display one of two images depending on value

[Karen_Labenz]

I want an green up arrow image to appear if a value is above a calculated number. If the value is below the calculated number, I want a red down arrow to appear.

This seem like it should work, but it always displays the first image, no matter what the number is:

If(current_qtr_revenue_variance<current_qtr_revenue_projection,image(“http://PATH/images/red%20down.png",30,30),image("http://PATH/images/green%20up.png”,30,30))

Any suggestions?

[Jean_Pierre_Traets]

Dear @Karen_Labenz , welcome to the Coda Maker Community

My first impression is that the it has to do with the IF statement.
The picture to be displayed if the condition is NOT met is missing in your formula

[Pch]

Hi @Karen_Labenz and Welcome to the Community !

How are your current_qtr_revenue_variance and current_qtr_revenue_projection gathered/calculated ?

[Karen_Labenz]

Variance: current_qtr_revenue_actual-current_qtr_revenue_projection

Quarterly revenue: Sum([Revenue By Product].[Q2 2022 Revenue])

Q2 Target Revenue: [Quarterly Revenue Projections].Filter([Target Period]=“Q2 2022”).[Expected Revenue]

Thanks!

[Karen_Labenz]

Do you know of any way to if/then/else?

[Jean_Pierre_Traets]

Dear @Karen_Labenz,

To be able to support it will be helpful if you shared a copy of your doc.

In case the doc contains confidential information, please replace it with fake records.

[Karen_Labenz]

Here is the doc: Dashboard sandbox

Thanks!

[Jean_Pierre_Traets]

Dear @Karen_Labenz,

Thanks a lot sharing the doc.
You should compare the target revenue to the actual revenue generated

The difference is only a calculated amount!

I have added two screenshots from both variants for your kind reference.

[Karen_Labenz]

Thank you so much! I really appreciate the help!