153
Hi Guys,
For example : I want if my price are matches with selected price, then display red colour in price.
As shown below example.
i am writing below color expression but didn't get right result.
My matches value shows red color, but i want N/A value shows black color.
Is any way to do this.
Thank you
Hi Nilam,
You can use the below expression in color section.
=Switch(Fields!Price.Value=Fields!Selected_Price.Value,"Red",IsNothing(Sum(Fields!Price.Value)),"Black",Fields!Price.Value<>Fields!Selected_Price.Value,"Black")
If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much.
I have already used that expression, but I didn't get right result.i.e.my N/A values are also coming in red color.
I want only, if price & selected price values are matches then only, price values show in red, otherwise remaining price values display as a black color.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
