Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
I'm trying to figure out how to calculate a running total of daily cash on-hand for each month so that I may calculate the average daily cash on-hand for each month. So, for the month of July, I would need to get a cumulative sum of the amounts in the Desired Output column for the month of July and then divide by 31 (example: ($248,919)+($401,761)+($554,037)+....and so on for the 31 days of July).
The dollar amounts in the Daily Cash Total column are a dimension that I've calculated in the script. What I'm trying to figure out is how in QlikView to get the figures that I have in the Desired Output column:
Date | Expenses | Revenue | Total Daily Activity | Daily Cash Total | Desired Output |
---|---|---|---|---|---|
7/1/2012 | 67,700.00 | (316,619.00) | (248,919.00) | (248,919.00) | (248,919.00) |
7/2/2012 | 110,012.00 | (13,935.00) | 96,077.00 | (152,842.00) | (401,761.00) |
7/3/2012 | 566.00 | 0.00 | 566.00 | (152,276.00) | (554,037.00) |
7/4/2012 | 106,578.00 | (15,582.00) | 90,966.00 | (61,310.00) | (615,347.00) |
7/5/2012 | 8,542.00 | (13,085.00) | (4,543.00) | (65,853.00) | (681,200.00) |
7/6/2012 | 0.00 | 0.00 | 0.00 | (65,853.00) | (681,200.00) |
Any suggestions would be much appreciated.
Kind regards!
Try rangesum(above(sum([Daily Cash Total]),0,rowno()))
Hello,
I know this post is quite old but I really need help. I have spent hours looking for an answer but can't find the correct one. I have a table with dates, accounts, amounts. I am trying to get a running total which seems easy. However, despite using a master calendar, I can't see the running total of a specific day if I don't have any entry that day.
Basically what I want to do is to be able to calculate my account balance at any time. Thus, if I don't have any entry on a specific day, I want to get the value of the running total the day before (or the day before that if there is no value).
I am stuck and would really really appreciate some help.
Thanks