Sum up values based on week ending date

[keeprollin]

Hello Community,

I have a date field, where Saturday and Sunday dates are rolled into Monday. I want to summarize the values based on each week's Friday Date. For example, my sample dataset is as given below:

Date	Value	Days	Rolled Days
2021-01-02	1	Saturday	Monday
2021-01-03	5	Sunday	Monday
2021-01-04	77	Monday	Monday
2021-01-05	34	Tuesday	Tuesday
2021-01-06	24	Wednesday	Wednesday
2021-01-07	23	Thursday	Thursday
2021-01-08	21	Friday	Friday
2021-01-09	53	Saturday	Monday
2021-01-10	13	Sunday	Monday
2021-01-11	23	Monday	Monday
2021-01-12	34	Tuesday	Tuesday
2021-01-13	12	Wednesday	Wednesday
2021-01-14	32	Thursday	Thursday
2021-01-15	13	Friday	Friday

In the above table, I want to summarize the entire week's value with each week ending on Friday. This would add the values belonging to each week, i.e., '2021-01-02' to '2021-01-08' and so on. So my expected output would be:

Date	Sum_Value
2021-01-08	185
2021-01-15	180

So far I have been able to convert Dates to Days and then rolled up Saturday and Sunday into Monday. I have attached the sample workflow for reference. Can someone please help me with the solution?

[BrandonB · Accepted solution]

You can use a multi-row tool to check if the previous row is a Friday and increment to the next week if so:

workflow attached

[IraWatt]

Hey @keeprollin,

Here is one way to do it:

You can create week groups using the multi row formula then summarize the groups using the summarize tool.

Any questions or issues please ask :)
HTH!
Ira