-
1. Re: Sum all the attending but exclude those in the last grade of each school
Deepak Rai Sep 8, 2017 9:58 AM (in response to Diogo Braga)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
-
Book1 (3).twbx 95.1 KB
-
-
2. Re: Sum all the attending but exclude those in the last grade of each school
Diogo Braga Sep 8, 2017 11:54 AM (in response to Deepak Rai)Thank you! Why CABA is not going away?!
-
3. Re: Sum all the attending but exclude those in the last grade of each school
Deepak Rai Sep 8, 2017 11:56 AM (in response to Diogo Braga)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
Diogo Braga Sep 8, 2017 12:26 PM (in response to Deepak Rai)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
Diogo Braga Sep 8, 2017 12:36 PM (in response to Diogo Braga)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
Deepak Rai Sep 8, 2017 4:41 PM (in response to Diogo Braga)Hi Diogo,
Check Screenshot and attached.
Thanks
Deepak
In the Calculation 1 instead of <> used earlier, now use =
-
Book1 (3).twbx 87.5 KB
-
-
7. Re: Sum all the attending but exclude those in the last grade of each school
Deepak Rai Sep 8, 2017 6:24 PM (in response to Diogo Braga)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
-
Book1 (3).twbx 116.5 KB
-
-
8. Re: Sum all the attending but exclude those in the last grade of each school
Deepak Rai Sep 8, 2017 6:28 PM (in response to Diogo Braga)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
-
Book1 (3) (1).twbx 91.2 KB
-
-
9. Re: Sum all the attending but exclude those in the last grade of each school
Diogo Braga Sep 8, 2017 7:30 PM (in response to Deepak Rai)Thank you so much for you help!