Help with Formula LI 'Currently Optimized Through'

neg177
Super Contributor

Help with Formula LI 'Currently Optimized Through'

Hi, 

 

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. 

 

Formula 

IF 'Y02 Accounts (Forecast)'.'Closing Balance (01)' < 1100000 AND 'S01 Time Settings'.Forecast Days AND 'S01 Time Settings'.Weekdays? THEN START() ELSE BLANK

 

Thank you 

0 REPLIES 0