Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Possible bug in ColorMix Wizard?

I think I may have found a possible bug in the colormix wizard, where it is not assigning a background color to the last column in a pivot table.

I tested another background color scheme (not colormix1 or from the wizard) on a copy of the same table.

Has anyone encountered this issue before? Any thoughts on a fix?

Here is an image showing that column 5 is not being colored.

Untitled.png

Here is the background color code from the broken table on the left

ColorMix1 ((1+Sign(2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))

/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1)

*Sqrt(Fabs((2*(avg(Cust_TotalGrossAmt)-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))

/(RangeMax (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total)))-RangeMin (top(total avg(Cust_TotalGrossAmt),1,NoOfRows(total))))-1))))/2,

ARGB(255, 248, 105, 107), ARGB(255, 99, 190, 132))

Here is the code from the table on the right

=If(avg(Cust_TotalGrossAmt) >= 10000,rgb(0,255,0),

rgb(255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000)),255 ,255-ROUND(255 *(avg(Cust_TotalGrossAmt)/10000))))

0 Replies