Make sure there is just enough data to make it clear what is needed. September 08, 2009 09: Regards, JG. This site in other languages x. Again, it is important that I am able to aggregate these values further show a total of absences by day count for a given time period.
I really just need a very simplified table of data, similar to this:. In the table, you'll also want to filter to exclude NULL values. Tech Sign In Page. The basic problem is to calculate for every day and every student ID the number of periods the student is absent or tardy.
Note- it's calculating half day for week days. While these table calcs are not difficult, they are a bit tedious and most of the items in the table report will require a table calc, since the class period level of detail is required in the view but you need your fields to operate at a higher level of aggregation. The requirement is to configure sick leave. Page 1 of 2 1 2 Last Jump to page: If that isn't possible, I understand. Bookmarks Bookmarks Digg del.
If I take calendar days then Saturday, Sunday are counted for reduction but 0.