=IIF( Sum(Fields!Percentile.Value, "RegionalSnaps") >= .10, "Yellow", "White")
I only want the ones above 10% to be yellow, otherwise white.
Any ideas anyone on why the entire range of cells are yellow and not just the one above 10%?
Ive tried both .10 and 10 for the value, and still the same thing
Because you're doing a sum, it's doing it for the entire dataset. If this expression is in a grouping e.g. table, matrix, list etc... then try changing the expresison to
=IIF( Fields!Percentile.Value >= .10, "Yellow", "White")
Effectively evalueated for every row in the group.
|||WOW, I've been searching for an answer for this for a long time, I really appreciate your time.|||You're welcome.
No comments:
Post a Comment