Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Nearly there with this...
I'm trying to colour code some text boxes but the coding is not as i want it.
I want the highest stop value to turn bright red. The formulae currently shades the values out of the grand total NOT the total of the selections and therefore none of the stops actually turn bright red
If I selected just Market St, Shudehill and Piccadilly then I would want Market Street to turn bright red and the other two stops lighter shades with the unselected stops not formatted at all
If I selected all the stops then I simply need the highest stop value to turn bright red and the others shaded accordingly
See attached..................
Hi.
ColorMix1(
(Sum({$<Stop={'SHU'}>}Revenue))/
Max(Aggr(Sum(Revenue), Stop)),
White(),
LightRed()
)