Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Any idea what is wrong with this expression? I keep getting error in expression.
Thanks
if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#),RGB(255,0,0)),RGB(0,0,0)))
Got it.....
if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#))),RGB(255,0,0),RGB(0,0,0)))
Got it.....
if(Sum(UnKnown_Cnt) / count(Empl.#) < .20,RGB(0,0,255),
if(Sum(UnKnown_Cnt) / count(Empl.#) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#))),RGB(255,0,0),RGB(0,0,0)))
try this,
=if(Sum(UnKnown_Cnt) / count(Empl.#) < 0.20,RGB(0,0,255),
if((Sum(UnKnown_Cnt) / count(Empl.#) ) > Sum(Total(UnKnown_Cnt) / count(Total(Empl.#),RGB(255,0,0)),RGB(0,0,0))
check bracket pls.