*** EXPRESSION ***

[solomonadjei]

Afternoon Experts,

Am struggling to write an expression to highlight or give me a background colour for the least Current Price highlighted in yellow based on my selection. I would appreciate if anyone could help.

Thanks

[miguelbraga]

Hey there,

You could make an expression like this in the background section of the Current Price expression:
=if(min([Current Price]) = [Current Price], Yellow(), White())

I think that this will work for you.

PS: please take note that the field [Current Price] need to be replaced with your expression.

Best regards,
MB

[rwunderlich · Accepted solution]

I think you need to include a TOTAL parm to consider all prices. 

=if(min(TOTAL [Current Price]) = [Current Price], Yellow(), White())

-Rob

[solomonadjei]

Thanks miguelbraga 🙂

[solomonadjei]

Thanks very much :).
It worked.

[Gabriel]

Hi,

try creating a variable like this

=MIN([Current Price])

Then use the variable in your IF statement for background color

=IF([Current Price] = $(v_MinCurrentPrice), Yellow())

Let me know if it works