9 Replies Latest reply: Aug 27, 2014 9:32 AM by Niranjan k

# Expression

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

Niranjan

• ###### Re: Expression

Just check values for the each section seperately

• ###### Re: Expression

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

• ###### Re: Expression

There is no value which can be >=0 (why -0?) and <=-10

Maybe you need >=-10 and <=0

• ###### Re: Expression

That is too a point to think

• ###### Re: Expression

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

Regards,

Niranjan

• ###### Re: Expression

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

• ###### Re: Expression

Niranjan,

Can you give an example of a number which is >=0 (OK, -0 if you wish), AND <=-10?

• ###### Re: Expression

Thank you Michael its working

• ###### Re: Expression

can you post a simple sample with 4 or 5 records