Re: Big question - Average of my account per month.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Pedrito Portugal (Portugal_at_discussions.microsoft.com)
Date: 09/30/04 

Date: Thu, 30 Sep 2004 07:15:02 -0700

This a new question.... I have inserted new 2 lines to ask you How I do if I
have more than one movement per day?
I have this table from the BANK:

DATE DEBIT AMOUNT CREDIT AMOUNT AVERAGE

2004-08-01 0 1000 1000
2004-08-05 0 500 500
2004-08-05 0 50 550
2004-08-05 0 50 600
2004-08-10 0 750 750
2004-08-15 -200 0 -200
2004-08-20 0 2000 2000
2004-08-25 0 1500 1500

Your first answer is ok if I dont have repeated days, but If I have more
than one movement fails... because i need to calculate the amount per day to
calculate the average per month. So, the amount of 2004-08-05 is 600, because
is the amount referenciated to that day.. do you agree?
Thanks a lot my friend!!!

"Aaron [SQL Server MVP]" wrote:

> > For the goal I dont need the follow lines:
> > 2004-08-05 500
> > 2004-08-05 550 ---> credit of 50
> > Only interest the last movement of the day.
>
> I'm extremely confused. With this data, how do you know which one was the
> last movement of the day?
>
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
>

Relevant Pages

  • Re: reversing a byte
    ... to reverse a byte. ... amount of time any operation requires, ... of space any executable code occupies, ... consumption of the computer running the code, ...
    (comp.lang.c)
  • Re: SPOILER: Independent 26/05/08 (was Re: SCWC 52 Results)
    ... *not* a definition and no amount of saying it loud will make it one. ... As I understand it the debate is whether the clue ... cryptic crossword purposes. ... the reverse of a definition - DIAL + a reversal indicator in the clue where ...
    (rec.puzzles.crosswords)
  • RE: Deriving Exactly XXX Amount of Weekdays
    ... (in reverse) ... Luke M ... "Rob" wrote: ... Either of the cells can hold any date and any amount ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Mergesort algorithm for linked lists
    ... are either ascending or descending, ... the reverse ordered set is also fully sorted ... amount of work to do and the greatest amount of auxilary space will be ...
    (comp.programming)
  • Re: LED Reverse Polarity Protection
    ... extremely intolerant of reverse breakdown. ... The amount of reverse current ... through a 1N400x diode is enough to cause actual damage. ... Then again, I never blew one of these LEDs at 9 volts, let alone 6. ...
    (sci.electronics.basics)