Skip to content

    • Archive

    Archive

    How do I calculate current year WTD sales and previous year WTD sales?

    Member
    in Archive

    I'm trying to calculate this week's WTD sales through yesterday and compare it to the same WTD sales for last year. Our week starts on Monday and ends on Sunday and I can't quite get our numbers to tie to a check that I've built in Excel.

     

    Here is the formula I'm using for this year's WTD sales in Domo:

     

    SUM(CASE
    WHEN WEEK(`date`,22) = WEEK(current_date()-1,22)
    AND YEAR(`date`) = YEAR(CURRENT_DATE()-1)
    AND DAYOFWEEK(`date`) < DAYOFWEEK(CURRENT_DATE()-1)
    THEN `totalsales`
    END)

     

    Any ideas on how to fix this?

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Comments

    • Member

      Hi,

      Is anyone able to help out with this request?


      Thanks,

    • Member

      Looking over it, the logic behind this makes sense.  Is it possible that the [mode] part of the function is causing the mismatch?  I'm not super familiar with the WEEK function, but I didn't see '22' as an option.

    • Contributor

      @Ctrix6 Hi, shouldnt it be DAYOFWEEK(`date`) <= DAYOFWEEK(CURRENT_DATE()-1)? 


      If youre not able to match the numbers maybe youre missing yesterday's data. 

      Just a thought.

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories