Rolling up Weekends Numbers to Friday

[MD2050]

Hello-

Is there a way we can roll up Saturday and Sunday numbers to Friday ? Following is the issue I am trying to solve .Thank you .

 

[LordNeilLord]

Hey @MD2050

You could update your workday column with the formula tool like so:

If workday in ('Saturday', 'Sunday') then 'Friday' else workday endif

Then use the summarize tool to sum value grouped by workday

Neil

[MD2050]

Hello Neil-

Thank you for reply. Please see attached my workflow , the issue is to retain the Friday's Date meaning 3/4,3/10 should be merged into 3/9. I cannot achieve that by Summarize tool. If you do a sum by Workday then yes I will get only Mon,Tues,Wed,Thu and Fri .

Thank you.

[subbarao · Accepted solution]

Write a formula,

If Day = Saturday, Date minus 1

If Sunday, Date minus 2

And Summarize by Date.

[MD2050 · Accepted solution]

Hello @subbarao-

Thank you for your suggestion, it worked . Please find in attached the updated workflow for reference. 

Thank You.

[LordNeilLord]

Hey @MD2050,

No problem, you can join back to your original data (after the summarize) using workday as the key field... This will give you the results you need