Summarize Boolean

andis
Occasional Contributor

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,

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
JaredDolich
Moderator

Re: Summarize Boolean

@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


Jared Dolich

View solution in original post

rob_marshall
Moderator

Re: Summarize Boolean

@JaredDolich 

 

Hey Jared, change the formula to be:

 

timesum(data module.sales) = 0

 

which takes out the IF statement.

View solution in original post

3 REPLIES 3
JaredDolich
Moderator

Re: Summarize Boolean

@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


Jared Dolich

View solution in original post

rob_marshall
Moderator

Re: Summarize Boolean

@JaredDolich 

 

Hey Jared, change the formula to be:

 

timesum(data module.sales) = 0

 

which takes out the IF statement.

View solution in original post

JaredDolich
Moderator

Re: Summarize Boolean

@rob_marshall Even better! Thank you!


Jared Dolich