Hi all,
I am facing out of object memory issue in a chat wich has the following formula: is there a btter a to write this formula or any other way to overcome this error message . i am 10 SR3
IF
(GetFieldSelections(Year) = 2013,
(if (sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) > sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome), 'qmem://<bundled>/BuiltIn/led_g.png',
if (sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) = sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome) and sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) >0 and sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome)>0, 'qmem://<bundled>/BuiltIn/led_o.png',
if ( sum({<Year={"$(vCurrentYear)"},YTD={'Yes'}>} OperatingIncome) =0 and sum({<Year={"$(vPreviousYear)"},YTD={'Yes'}>} OperatingIncome)=0,0,'qmem://<bundled>/BuiltIn/led_r.png')))),
(if (sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) > sum({<Year={"$(vPreviousYear)"}>} OperatingIncome), 'qmem://<bundled>/BuiltIn/led_g.png',
if (sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) = sum({<Year={"$(vPreviousYear)"}>} OperatingIncome) and sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) >0 and sum({<Year={"$(vPreviousYear)"}>} OperatingIncome)>0, 'qmem://<bundled>/BuiltIn/led_o.png',
if ( sum({<Year={"$(vCurrentYear)"}>} OperatingIncome) =0 and sum({<Year={"$(vPreviousYear)"}>} OperatingIncome
)=0,0,'qmem://<bundled>/BuiltIn/led_r.png')))))