Bank Balance Type Report

[kangaroomac]

Hi All,

I am trying to do a mimic of a "Bank Balance" type report. What I have is transactions happening with a transaction date. I have a cumulative amount adding each transaction.

There is a limit (in the demo set to 2000 in a variable). What I then do is see Balance (Limit - Cumulative). This all works if I have the TransactionDate going in Ascending order.

What I would like to do is have TransactionDate going in Descending order (i.e. Last Transaction showing first) with Balance having the lowest amount on top - with other words latest date showing latest balance.

I have attached a sample of what I mean.

Anyone have any ideas?

Thanks in advance.

[Gysbert_Wassenaar]

You can calculate the cumulative amount in the script. See attached qvw.

[sujeetsingh]

Please try to understand the assosiation of data ...

-when you short the  TransactionID to decreasing...4,3,2,1.....

-then the expression will be throwing values related to the TransactionID how can ot chanse the data related to the expression got it....

It is all the data you are having for each transaction.

[#4 · Accepted solution]

I guess you could do it like this.

This way, you can have the table sorted however you want...

Cheers

Martin

[kangaroomac]

Thanks guys,

Both worked, but for the real problem the expression option will work better.

Thanks again.