Calculation to set text color

[tmumaw]

Hi everyone,

It's late Friday afternoon and eyes aren't working too good.  Does anyone see anything wrong with my statement:

Thanks

If(Node4 = 'A43A000000',Round(sum({<FISYR = {$(=$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_SALESCOSTS2'}>} [In company code currency_HSL]) /
sum({<FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1}, NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}>} [In company code currency_HSL] * -1),0.001) > Sum({<[DIV Tops Category] = {'Sales Deductions'}>}[DIV Top]),RGB(255,0,0),RGB(0,102,0)),
If(Node4 = 'A42A000000',Round(sum({<FISYR = {$(=$(vFisYr) - 0)},[GL Hier 1] = {[ZMR Chart of Accounts]}, YTDFlag = {1},[HighNode] = {'ZMR_SALESCOSTS2'}>} [In company code currency_HSL]) /
sum({<FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1}, NodeIDGLAccountsName = {ZMR_GROSS.GLPCT}>} [In company code currency_HSL] * -1),0.001)> Sum({<[DIV Tops Category] = {'Sales Deductions'}>}[DIV Top]),RGB(255,0,0),RGB(0,102,0)) 

[tajmohamed30]

what error it's showing, have you tried set analysis builder

Set Analysis Wizard for QlikView | qlikblog.at