9 Replies Latest reply on Sep 8, 2017 7:30 PM by Diogo Braga

# Sum all the attending but exclude those in the last grade of each school

I need an aggregation that excludes the value of the last grade level for each school (as shown in the red square)

The value is in reference to attending students, I need to sum all the attending but exclude those in the last grade of each school.

Thank you!

• ###### 1. Re: Sum all the attending but exclude those in the last grade of each school

Hi Diogo,

Please Check screenshot and attached. It looks you have some data in case of CABA, so it is not going away.

Thanks

Deepak

1 of 1 people found this helpful
• ###### 2. Re: Sum all the attending but exclude those in the last grade of each school

Thank you! Why CABA is not going away?!

• ###### 3. Re: Sum all the attending but exclude those in the last grade of each school

It shows maximum month as 11 but there is no data ..please check the sheet where i did some monthly analysis

• ###### 4. Re: Sum all the attending but exclude those in the last grade of each school

Yes, it's fine. Your solution works! Thank you!

• ###### 5. Re: Sum all the attending but exclude those in the last grade of each school

Now I need to reverse the logic.

I need to show all the schools and grades that was excluded from this calculation. Let me know if I should start a new discussion.

• ###### 6. Re: Sum all the attending but exclude those in the last grade of each school

Hi Diogo,

Check Screenshot and attached.

Thanks

Deepak

In the Calculation 1 instead of <> used earlier, now use =

• ###### 7. Re: Sum all the attending but exclude those in the last grade of each school

I Corrected it. Just filtered out Null Values in Context Filter and then CABA and others are working. See attached for both cases.

Thanks

Deepak

• ###### 8. Re: Sum all the attending but exclude those in the last grade of each school

For Reverse Logic. You will See that values for CABA and Clay which are 9 and 54 now showing. Again moved 16-17 to context and selected non null from Special values.

Thanks

Deepak

1 of 1 people found this helpful
• ###### 9. Re: Sum all the attending but exclude those in the last grade of each school

Thank you so much for you help!