Colormix by Normalizing Row Data

[cfountain72]

Hello,

I would like to normalize each row's data seen below from -1 to 1 to then apply a ColorMix2. The columns are setup by variable so they can be presented by Month or by Week. Any suggestions on what the proper formula should be?

Thanks in advance,

Chris