Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi if someone could help me it will be great.
I have a table with
DATE | AMOUNT | CODE |
how can I create a closing Balance for each of the codes ?
DATE | AMOUNT | CODE |
30/11/2005 | -97.98 | 2100 |
30/11/2005 | -81.65 | 7306 |
30/11/2005 | -16.33 | 2201 |
30/11/2005 | 16.33 | 2201 |
30/11/2005 | 81.65 | 7306 |
30/11/2005 | 97.98 | 2100 |
01/01/2009 | -294.8 | 2100 |
01/01/2009 | 38.45 | 2201 |
01/01/2009 | 256.35 | 5000 |
14/01/2009 | -543.86 | 4000 |
14/01/2009 | -81.58 | 2200 |
14/01/2009 | 625.44 | 1100 |
16/01/2009 | -97.89 | 4000 |
16/01/2009 | -14.69 | 2200 |
16/01/2009 | 112.58 | 1100 |
19/01/2009 | -7091.3 | 4000 |
19/01/2009 | -1371.74 | 4000 |
19/01/2009 | -1063.7 | 2200 |
19/01/2009 | -928.77 | 4000 |
Hi Richard, The above requirement seems to be confounding. Could you showcase the data and what exactly you are looking for like before and after?
I've added a block of the data.
DATE | AMOUNT | CODE |
30/11/2005 | -97.98 | 2100 |
30/11/2005 | -81.65 | 7306 |
30/11/2005 | -16.33 | 2201 |
30/11/2005 | 16.33 | 2201 |
30/11/2005 | 81.65 | 7306 |
30/11/2005 | 97.98 | 2100 |
01/01/2009 | -294.8 | 2100 |
01/01/2009 | 38.45 | 2201 |
01/01/2009 | 256.35 | 5000 |
14/01/2009 | -543.86 | 4000 |
14/01/2009 | -81.58 | 2200 |
14/01/2009 | 625.44 | 1100 |
16/01/2009 | -97.89 | 4000 |
16/01/2009 | -14.69 | 2200 |
16/01/2009 | 112.58 | 1100 |
19/01/2009 | -7091.3 | 4000 |
19/01/2009 | -1371.74 | 4000 |
19/01/2009 | -1063.7 | 2200 |
19/01/2009 | -928.77 | 4000 |
I just need to know how to calculate the closing balance for each code even if that means I need to put the opening balance that would be even better.
This is a front-end approach
Sum(Aggr(Sum(AMOUNT),CODE))
Thanks for this Peter.