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!
