avg = ((dailywork.nmen+dailywork.nwmn+dailywork.nadl)/(pkg.nripe+pkg.ngreen)) DO CASE CASE avg >= 0 and avg < 20 nColor = RGB(0,0,100) CASE avg >= 20 and avg < 30 nColor = RGB(100,0,100) CASE avg >= 30 and avg < 40 nColor = RGB(200,0,100) CASE avg >= 40 and avg < 60 nColor = RGB(0,100,100) CASE avg >= 60 nColor = RGB(0,200,100) ENDCASE RETURN ncolorAnd in the Init of the Grid...
ogrd.SetAll("DynamicBackColor", "getAVG([Dailywork.nmen+Dailywork.nwmn],; [Pkg.nripe+pkg.ngreen])", "Column")Will you be able to help me as to where I've gone wrong?