Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I think you need to include a TOTAL parm to consider all prices.
=if(min(TOTAL [Current Price]) = [Current Price], Yellow(), White())
-Rob
I think you need to include a TOTAL parm to consider all prices.
=if(min(TOTAL [Current Price]) = [Current Price], Yellow(), White())
-Rob
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