Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Exprerts,
=if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=-10,RGB(153,0,0),RGB(147,193,150))
could some one help me im not getting result whats the error
expression correct,i dont know how to write in between >=-0 and <=-10
some one guide me
Thanks In Advance
Niranjan
Niranjan,
Can you give an example of a number which is >=0 (OK, -0 if you wish), AND <=-10?
Just check values for the each section seperately
There is no value which can be >=0 (why -0?) and <=-10
Maybe you need >=-10 and <=0
Hi Sujeet,
Thanks you so much i will do that,But Expression its not showing Exact colors
You have any sample expressions
if(sum(values)>=-0 and sum(values)<=-10,RGB(153,0,0),RGB(147,193,150))
like this
Regards,
Niranjan
That is too a point to think
Hi Michael,
I have minus values also in pivot here if its between >=-0 and <=-10
i want to show background Light Red or else Dark Red
any Suggestions please
Regards,
Niranjan
can you post a simple sample with 4 or 5 records
Hi,
if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=10,Green(),
if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=10,RGB(147,193,150),This is working fine
if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-10,RGB(153,0,0),
if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=-10,RGB(153,0,0))))),This one is not working
Regards,
Niranjan
Niranjan,
Can you give an example of a number which is >=0 (OK, -0 if you wish), AND <=-10?
Thank you Michael its working