Arrow Over a Expression.

[#1]

Dear Friends. I am having Table chart, using expression SUM([Debit Amount] to show Amounts for all months and Year well.

I want to use a Arrow Marks ups and downs to show up that last month Amount is more than current month and vice versa.

I am using this expression on the lable field of Expression

=if(Max([Debit Amount],Month) < max([Debit Amount],Month-1),'qmem://<bundled>/BuiltIn/arrow_n_r.png',)

which is not working. Please help

[antoniotiman]

Hi Vivian,

my e-mail  mancini@teseo.it

Regards

[#3]

Dear All.

Thank you for views and support.

I have Followd ANTONIO MANCINI suggession, and its successfully working.

Here is the CODE given by ANTONIO MANCINI for reference

If(RowNo() > 0 and Dimensionality() > 0,

if(Before(sum([Debit Amount])) > sum([Debit Amount]),

'qmem://<builtin>/Arrow_S_R.png','qmem://<builtin>/Arrow_N_G.png'))

[#4]

Dear ANTONIO,

I also want to skip arrow if the value is zero,

i tried this, it worked for down arrow, but not up arrow.

If(RowNo() > 0 and Dimensionality() > 0,

if(After(sum([Debit Amount])) > sum([Debit Amount]) and sum([Debit Amount])>0,

'qmem://<bundled>/BuiltIn/arrow_s_g.png'),

If(RowNo() > 0 and Dimensionality() > 0,

if(After(sum([Debit Amount])) < sum([Debit Amount]) and sum([Debit Amount])>0,

'qmem://<bundled>/BuiltIn/arrow_n_r.png')))

[antoniotiman · Accepted solution]

if(RowNo() > 1 and Dimensionality() > 0 and [Debit Amount] <> 0,...........

[#6]

Dear ANTONIO,

Thank you, its working