Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm trying to set some colors based on a value in a text box. Does anyone see anything wrong with this statement? Colors not working. Thanks
=Num(if(Sum({<FISYR = {$(=$(vFisYr) - 0)},YTDFlag = {1}>} [Inv Gross]) - Num(Sum({<FISYR = {$(=$(vFisYr) - 1)},YTDFlag = {1}>} [Inv Gross]) < 0),RGB(255,0,0),RGB(0,102,0)))
Sorry Sunny forgot to accept the solution. Thanks