Adding an Amount from a Prior Week
Hello,
I am currently trying to get a sum from two values. One of the values is from the most recent Sunday, and the other is the Sunday prior to the most recent one. I need to find the difference of them for a calculation I am using in another column. I am not sure of how to call upon the prior Sunday's value. I do have dates associated also. My idea was to have an If function that calls upon the column to check if it is sunday. Then to sum up the most recent week's value with the prior weeks, by using the Date column to do (Date@row-7) to get to the correct row. My issue now is how do I call upon the value column after that. Below is the formula I currently have. Any help will be greatly appreciated.
=if([Choose the Day]@row = "Sunday", sum([Body Fat Percentage]@row,(Date@row-7 ?????
Kind Regards,
Pete
Answers
-
Are you able to provide some screenshots for reference?
-
Hi Paul, please see attached. You can see that there is a difference between the body fat percentages. I need the formula in the "Body Fat % Change" column to be able to refer to previous weeks body fat and find the difference between that number and the current week. I am just unsure how to call upon the previous week's every time.
-
Are you going to also need to include certain criteria such as the name for unique identification, or are you just looking for the last entry, or are you looking for the last "Sunday" entry? Is it a combination of some/all of those? Is it something different, and I am just completely missing the target here?
-
Hi Paul, I am sorry for not being more clear. I do need the Body Fat Percentage along with the name from the prior week. As the name will help associate who's body fat percentage is whoever's. I truly appreciate the help here. I am guessing I need to use some sort of SUMIFS formula now.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!