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)))
But this is a color expression, isn't it?
=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),RGB(255,0,0),RGB(0,102,0),'$###,###,##0')
There are two different location... one is the general tab where you have your expression and then you have font tab where you use color expression. What is confusing me is that why do you need to format the expression which goes on the font tab?
Try this
=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),
RGB(255,0,0),
RGB(0,102,0)
)
Nope
=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),RGB(255,0,0),RGB(0,102,0),'$###,###,##0')
It does not like RGB on.....
I am using it in a text box to show either a positive or negative variance. If the calculation returns 0 or less it's red otherwise green.
I'm using it to format the value in the text box....
But this is a color expression, isn't it?
=If((Sum({<FISYR = {$(=$(vFisYr) - 0)}, YTDFlag = {1}>} [Inv Gross]) - Sum({<FISYR = {$(=$(vFisYr) - 1)}, YTDFlag = {1}>} [Inv Gross])) < 0),RGB(255,0,0),RGB(0,102,0),'$###,###,##0')
There are two different location... one is the general tab where you have your expression and then you have font tab where you use color expression. What is confusing me is that why do you need to format the expression which goes on the font tab?
Can you Try this
=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)))
I have changed the Postion of equal to(=) in Double dollar sign expansion