How to pick up my previous day not including weekends
I would like to some advice on how I can pick up my previous day not including weekends. Ex) My previous day for Monday would be Friday. This is the Formula I tried to use below. I have a Time Filter Line Item that marks 0 for any weekday and 1 and 2 for weekends, so I can try and only pick up the 0's. Below is my formula.
IF 'S01 Time Filter'.Weekdays? THEN PREVIOUS('Y01 Collection_Funding'.'Securitization (including WO)') + 'S01 Time Filter'.Days from next business day ELSE 0