Formula Help

neg177
Super Contributor

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 

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

@neg177 

 

Did the above help?

View solution in original post

2 REPLIES 2
rob_marshall
Moderator

@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

rob_marshall
Moderator

@neg177 

 

Did the above help?