Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))
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')))
if(RowNo() > 1 and Dimensionality() > 0 and [Debit Amount] <> 0,...........
Dear ANTONIO,
Thank you, its working