Group, I am trying to color the highest value, in this example ROC. I have tried: AddColumn(ROC5,"Roc5",2.2,colorDefault,IIf(ROC5>Foreign ( "~MyROC5", "C" )/Foreign( "~MyROC5", "I" ),colorGreen,colorRed)); This does colorGreen the ROC that is above the average ROC in the column.
I have tried various methods of this below but no luck. AddColumn(ROC2,"Roc2a",2.2,colorDefault,IIf(ROC2 < Highest( ROC2 ) ,colorGreen,colorRed)); Any thoughts? Tia John