Module 1 has a model calendar, and module 2 doesn't use it. The model calendar has two future years & past years. I wanted to summarize the boolean of Module 1 in Module 2. I didn't get the expected result when I was implementing ANY & TIMESUM functions.
Please advise me.
If you're open to a slightly different way, I would handle it this way:
In our planning module we have some employees with sales others without.
In our system module we have a Boolean that checks for zero sales across time. If there are no sales, then set the Boolean to TRUE and mark for deletion.1
Hey Jared, change the formula to be:
timesum(data module.sales) = 0
which takes out the IF statement.2
@rob_marshall Even better! Thank you!2