Home » Developer & Programmer » Reports & Discoverer » Cumulative balance of (w xp )
Cumulative balance of [message #431120] Sun, 15 November 2009 10:20 Go to next message
mosab
Messages: 2
Registered: August 2009
Location: iraq
Junior Member

accno number customer account number

d_date date history of the movement

in_m amount in

Quantity out_m out


How I could know the balance to a specific date, and not the final balance

I mean, for example in the history of 1/1/2009, the balance 1000

30.1.2009 in the history of the balance 2000

How do I make a report that displays the balance group by date in the by date of how the balance of the customer

The report of the movements and balance against it on that day, I was moved, which depends on the previous day, as you know


please help me

like this
report

accno date in out balance
25 1/1/2009 100 0 100
25 1/1/2009 100 50 150

25 30/9/2009 100 50 200
25 5/10/2009 100 20 280





becom final report lik this

group





accno date in out balance
25 1/1/2008 200 50 150
25 30/9/2009 100 50 200
25 5/10/2009 100 20 280
Re: Cumulative balance of [message #431121 is a reply to message #431120] Sun, 15 November 2009 10:47 Go to previous message
Michel Cadot
Messages: 63804
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sum(in-out) over (partition by accno order by date)

Regards
Michel
Previous Topic: I wants the formula column to be implemented
Next Topic: Want group column and its total in down side
Goto Forum:
  


Current Time: Mon Sep 26 16:17:53 CDT 2016

Total time taken to generate the page: 0.08690 seconds