Forum Discussion

yannick90's avatar
yannick90
Frequent Visitor
4 years ago
Solved

Auto select previous date

Hello guys, I'm coming up to you with an issue that has been frying my brain lately. Long story short, right now I'm comparing the data of two dates (this week vs previous week) hence on my calendar...
Need Help
  • yannick90's avatar
    yannick90
    4 years ago

    hi danextian ,

     

    Thanks for all the support. The user decided to go with a different approach instead. 

danextian's avatar
danextian
Super User
4 years ago

Are you trying to compute for the value in the last 7 days a week ago or the value 7 days ago?

yannick90's avatar
yannick90
Frequent Visitor
4 years ago

Hello danextian,

 

I'm a bit confused by your statement. let me give a bit of context, the file is updated every monday. For example it was updated on April 24th, then May 1st and so on. So the scenario goes like this (take the data of "this week which is May 1st" and compare it to the data of last week which is April 24th

 

There is already a formula in place that is giving me the value of this week (2,8 millions) and last week (2,9 millions). 

Now the objective is to get the value of difference and variation by just selecting this week's date rather than selecting this week and last week

 

Let me know if it answers your question

Thanks  

  • danextian's avatar
    danextian
    Super User
    4 years ago

    What i was trying to say was, if today is Jan 30, are you trying to compare Jan 30 with Jan 23 or the from Jan 23 to 30 vs Jan 16 to Jan 22? 

    • yannick90's avatar
      yannick90
      Frequent Visitor
      4 years ago

      danextian I see now, I am trying to compare Jan 30 with Jan 23