Display image according to the value!

[#1]

Hi All,

I want to display the image according to the sales value. (i,e) If the sales value is in +ve when compared to the last month then there should be some image should be displayed, if the values is in -ve then there should be some image and if in the both the months there is no sale happened then there should be some image displayed.

Something is like this.

2006 2007 Variance Image
A1 B1 +ve Image1(This image i am able to display)
A2 B2 -ve Image2(This image i am able to display)
A3(0) B3(0) 0 Image3(This image i am not able to display)

I used below expression:


if(Sum(SalValue) - before(Sum(SalValue)) < 0,'qmem://<bundled>/BuiltIn/arrow_se_r.png','qmem://<bundled>/BuiltIn/arrow_ne_g.png')

Using the above expression i am able to do the first 2 rows but not the 3rd row.

Let me know what changes i need to do!

[#2]

if(Sum(SalValue) - before(Sum(SalValue)) < 0,'qmem://<bundled>/BuiltIn/arrow_se_r.png',if(Sum(SalValue) - before(Sum(SalValue)) =0,'qmem://<bundled>/BuiltIn/arrow_e.png',,'qmem://<bundled>/BuiltIn/arrow_ne_g.png')

Should do it...

[#3]

Sorry! It's not working! Any other solution please...

[#4]

try this:

if(Sum(SalValue) - before(Sum(SalValue)) = 0,'qmem://<bundled>/BuiltIn/arrow_e.png',

if(Sum(SalValue) - before(Sum(SalValue)) > 0,'qmem://<bundled>/BuiltIn/arrow_ne_g.png',

if(Sum(SalValue) - before(Sum(SalValue)) < 0,'qmem://<bundled>/BuiltIn/arrow_se_r.png', Null())))

regards