I have some basic code that takes a percent of the previous days value and carries it over to the next day using lag(). I have certain dynamic days (like christmas) that I would like to passover and skip the lag() and put it on the following day breaking the normal lag1(). Any ideas how I can do this? Date X (random) 25% of previous total Total 12/16/2022 14 14.0 12/17/2022 11 3.5 14.5 12/18/2022 8 3.6 11.6 12/19/2022 5 2.9 7.9 12/20/2022 2 2.0 4.0 12/21/2022 7 1.0 8.0 12/22/2022 14 2.0 16.0 12/23/2022 9 4.0 13.0 12/24/2022 6 3.2 9.2 12/25/2022 - - - 12/26/2022 5 2.3 7.3 Skips 12/25 12/27/2022 6 1.8 7.8 12/28/2022 8 2.0 10.0
... View more