Day to Day growth Ignoring weekends and holidays.

[saurav_palekar]

Hi Alteryx Community, I hope you all are doing well. I'm new to the community and would appreciate your help in getting a solution to a problem.

Please find attached sample dataset for reference.

I have daily values that needs to be filled based on the previous values. I need to ignore all the weekends and holidays and only populate values for the business days. For weekends and holidays I have added '0' as value so that you'll know what dates are weekends and holidays.

I need to fill daily growth of 2% in a next working day based on value of previous working day.

Appreciate your help. Please let me know if you have any questions! 

Thank you so much!

[Bren_Spill2 · Accepted solution]

Hi @saurav_palekar - see if the attached helps. Thanks!

[saurav_palekar]

Thank you so much Brendan. This worked for me!

[Bren_Spill2]

You're welcome!