Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
what error it's showing, have you tried set analysis builder