Calculation for Color

[tmumaw]

Hi All,

Having a little problem with a statement trying to set text color, but not working.  Need a little help.

Thanks

Round(sum({<Node3 = {'A420000000'},FISYR = {$(=$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_SALESCOSTS2'}>} [In company code currency_HSL]) /
sum({<Node3 = {'A420000000'},FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1}, NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}>} [In company code currency_HSL] * -1),0.001 >= [SL Top],RGB(255,0,0),RGB(0,204,0)

[Anil_Babu_Samineni · Accepted solution]

How about this?

If(Round(sum({<Node3 = {'A420000000'},FISYR = {$(=$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_SALESCOSTS2'}>} [In company code currency_HSL]) /
sum({<Node3 = {'A420000000'},FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1},NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}>} [In company code currency_HSL] * -1),0.001) >= [SL Top],RGB(255,0,0),RGB(0,204,0))

[tmumaw]

perfect.....thanks