Formula Help

Hi, 

 

I'm trying to create a formula that will output the date based on a TRUE/Checked Boolean. 

neg177_0-1635286074027.png

neg177_1-1635286211186.png

We are looking to be able to bring in the date for the Line Item '10th of the Month' based off of the Boolean. Please advise on how to make this possible, 

 

Thank you 

Best Answer

Answers

  • @neg177 

     

    Create another line item( '10th of Month') in the SYS Time module,  if '10th of Every Month' then item(time) else blank.  Then set the summary to LastNonBlank.

     

    Then, in the first module, '10th of Month'[lookup:First Forecast Period]

     

    Rob