Hi All

I want to gradient fill a column from red (lowest value) to green (highest value). I am using a funtion found here :https://docs.microsoft.com/en-us/arc...-tables-charts

I am passing the bacground colour to the function with the following expression :


Code:
=code. ColorRYG(Fields!BlokkeklaarPersentGelewerKultAliasnaam.Value,Fields!BlokkeklaarmaksimumKultAliasnaam.Value,Fields!BlokkeklaarminimumKultAliasnaam.Value,40)
Also I am using a filter and the values gives different values for different filters. I have read through the algorithm logic, but are unsuccessful in determining the last parameter (i.e. 40 in the example above.). Obviously it would change for every set of data I use (based on the filter). How can I calculate the value.

Regards