Results 1 to 3 of 3

Thread: Running total of sales prior to now.
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Jun 2014
    Posts
    205
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Running total of sales prior to now.

    Hi, I have sales by the hour. Each hour I have a cell with the total sales.

    I'm looking for the best way to have running total, but if the time is after now it will display 0.

    1pm $200 $200
    2pm $150 $350
    3pm $ 75 $425

    But if the time is after now then dont give the hourly totals.

    So something with =now(), <1pm?

    Thanks

  2. #2
    New Member
    Join Date
    Jan 2018
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Running total of sales prior to now.

    Hey shophoney,

    Assuming column A contains the time 1pm,2pm etc.. Make sure these values are configured are numbers and not strings

    =IF(A1>HOUR(NOW()),SUM(200$,etc..),"")

    Cheers,

    Hurkk
    Last edited by Hurkk; Sep 17th, 2019 at 06:11 PM.

  3. #3
    Board Regular
    Join Date
    Jun 2014
    Posts
    205
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Running total of sales prior to now.

    Hi, thanks for the response.

    My issue might be with the TIME formula being a cubemember. See below, I only need the time part not the date.

    =IFERROR(CUBEMEMBER("ThisWorkbookDataModel","[TIME].[TIME].&[1899-12-30T23:00:00]"),"")

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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