Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    464

    Unanswered: subtracting 3pm data from 4pm data and so on...

    Hi

    I'm looking for a way to subtract I have a table that contains data for every hour of the day. The values coming in every hour are accumulative. How can I subtract the value received at 12am from the value received at 1am and the value received at 1am from the value received at 2am.....and so on?

    Appreciate any advice...

    Regards
    Last edited by shajju; 07-08-09 at 08:48.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Research use of LAG and/or LEAD functions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •