Summarize Boolean

Hi there,



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.





Best Answers

  • JaredDolich
    Answer ✓


    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.


  • @JaredDolich 


    Hey Jared, change the formula to be:


    timesum(data module.sales) = 0


    which takes out the IF statement.