Help with Formula LI 'Currently Optimized Through'
I'm trying to create a formula that will pick up the first day when the LI 'Y02 Accounts (Forecast)'.'Closing Balance (01)' is less than 1 million in the forecasting days. The formula below is what I created. It is not pulling in a date.
IF 'Y02 Accounts (Forecast)'.'Closing Balance (01)' < 1100000 AND 'S01 Time Settings'.Forecast Days AND 'S01 Time Settings'.Weekdays? THEN START() ELSE BLANK