I am trying to calculate Total sales for business weeks. We have a couple of dollar sales on holidays that I would like to count on next business day. Trying to figure out the best way to accomplish that. I have working days column available in the date table but I am not sure how can I make sure the sales gets added to the next business day.
Any help would be appreciated.