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.
Hello Nilam,
You use below Expression
=IIF(Fields!price.Value = Fields!SelectedPrice.Value ,"Red","Black")
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,134 Super User 2024 Season 2
Martin Dráb 229,928 Most Valuable Professional
nmaenpaa 101,156