Summarize Boolean

Hi there,

andis_0-1615475685489.png

 

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.

 

Thanks,

 

 

Best Answers

  • JaredDolich
    Answer ✓

    @andis 

    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.

    timesum004.png

     

    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.

    TimeSum005.png

  • @JaredDolich 

     

    Hey Jared, change the formula to be:

     

    timesum(data module.sales) = 0

     

    which takes out the IF statement.

Answers