Expression

[NavinReddy]

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

[sujeetsingh]

Just check values for the each section seperately

[Anonymous]

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

Maybe you need >=-10 and <=0

[NavinReddy]

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

[sujeetsingh]

That is too a point to think

[NavinReddy]

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

[sujeetsingh]

can you post a simple sample with 4 or 5 records

[NavinReddy]

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

[Anonymous · Accepted solution]

Niranjan,

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

[NavinReddy]

Thank you Michael its working