Each column in a report needs to be assign a parameter that indicates what is to be done with that column for the summary row.  The following parameters are availabe:
 

Break

When using "Tabulate", one and only one column needs to be selected to be the "Break" column.  Generally that column was also the primary sort field in "PostSort".  Tabulate will create a summary row in the output file when the value in the break field changes.  In the sample below the "ID" is the break field.

As the default, Tabulate only prints the summary row in the output file.  However, you can print the all the detail lines by checking the "Display Details" check box.

Average

Average calculates the numerical average of the numerical entries in that column rounded to the nearest whole number.  Cells that contain text and cells that are empty are not used in the calculations of the average.

In this table there are 5 detail rows and one summary row.  The summary row is calculated and printed when the value in the "ID" column changes.

Count

There are two Count parameters: "Count all" and "Count Numeric".  "Count All" counts the number of rows regardless of what each cells contains whereas "Count Numeric" only counts the number of cells in the column that contain a numeric value. When using count all, the data type should be set to "Text" in the second dropdown box.  When using count numeric, the data type must be set to "num" in the second dropdown box.

Cr to Courses

Converts "Credits" to "Number of Courses".  The current column must contain course credit.  To calculate the value of the field for each row, it takes the credit and multiples by 2 (the default) and truncates to a whole number.  A course credit of 0.5 calculates as 1 course. A course credit of 0.75 calculates as 1 courses.  A course credit of 1 calculates as 2 courses. If you use a different credit scheme, you may need to modify the values exported by PowerSchool if you wish to use this parameter.  The value displayed on the summary row is the sum of the values calculated for each row. The sample below is for courses given credit at the end of the semester.

You may change the multiplier by entering a different value in the constant field.  The sample below is for courses given credit at the end of the school year.

Cr to Passing

Converts "Credits" to "Number of Courses Passing".  The current column must contain "course credit".  The column immediately to the left must contain the "Percent" and must not use the constant field.  Using the parameter "Display" or "Ignore" are the best two choices. To calculate the value of the field for each row, if the Percent is "70 or greater" (the default), it takes the credit and multiples by 2 and truncates to a whole number otherwise it calculates as a zero.  A course credit of 0.5 calculates as 1 course when the percent is 70 or above. A course credit of 0.75 calculates as 1 courses.  A course credit of 1 calculates as 2 courses. If you use a different credit scheme, you will need to modify the values exported by PowerSchool if you wish to use this parameter. The value displayed on the summary row is the sum of the values calculated for each row.

You can change the passing cutoff grade by entering a different value in the constant text box in the percent column.

Display

Displays the contents of the cell in the last detail row in the summary row.  Notice in the sample below, the summary row contains "PE104" which is the value in the last detail row.

If the values in the colum are not all the same, it is best to use the "Ignore" parameter rather than the "Display" parameter as shown below.

Formula

"Formula" can be used to do calculations across several columns.  In the following example, the "Formula" parameter is used to find the average of three grades.  Letters are used to indicate which column values to use in the calculations.  Thus B is the English grade, C is the Math grade, and D is the Science grade. In the sample below, the detail lines are not displayed, and since not field is indicated as the "Break" field, a summary rows is produced for each detail row.

By using the INT function we can round off the average to a specific number of places to the right of the decimal point.  Using 100 for the multiplier and divider, we can either truncate or round off two places.

To truncate to 2 places use: INT((B+C+D)/3*100)/100
To round of to 2 places use:  INT((B+C+D)/3*100+0.5)/100

In addition to constants (numbers) and column Letters all the symbols in the table below may be used in formulas.
 

Group

The "Group" parameter will allow you to group like records in their own table or on a separate page. In order for the group function to work properly the data must be sorted in PostSort by the "Group" field prior to running Tabulate.  In this example a different table is created for each homeroom.

To have the table for the next group start on a new page, check the "New Page on Group" check box.

If Flag

The "If-Flag" parameter allows you to make a decision based on the results of a formula. This sample is for an honor roll report. Student names have been removed in the samples below.

This school uses on numerical grades.  The data exported out of PowerSchool is as shown below. The fields are student name, Class, Course name, Teacher Name, Exclude from Honor Roll Flag, Course Credit, Percent, Percent, Percent, Grade, Percent, and Percent.  The first 3 Percents will be used for counting Total number of grades, grades 93 or above, and grades 85 or above. The Grade field will be used to check for incompleted.  The last two fields could be anything - they are place holders.

The honor roll rules specify that a students must be taking five classes and may not have any incompletes. For honors all grades must be 85 or above. For High Honors all grades must be 93 or above.  If the Exclude from Honor Roll Flag is checked (1), the student can not be included in the honor roll regardless of his/her grades.

These are the parameters:
A - Break - Summary line produced when a new student is found
B - Group - Each Class has its own table
C & D - Ignore - Used for informational purpose when detail lines are displayed
E - Sum all - Adds up the "Exclude from Honor Roll" Flags.  If the sum is greater than zero, student can not be on honor roll
F - Cr to Courses - Counts total number of courses - Some courses count for more than one of the five required
G - Count all - Counts total number of grades
H - Count numeric - Counts grades 93 or above
I - Count numeric - Counts grades 85 or above
J - Count all - Counts incompletes (for display purposes - not needed in calculations)
K - Checks for Honor roll using formula: E=0 AND F>=5 AND H<G and G=I
       E=0 - Has no "Exclude from Honor Roll" Flags checked
       F>=5 - Taking at least 5 courses
       H<G - Numer of grades >= 85 is less than number of grades >=  93 (Don't include high honor students)
       H=I - Number of grades >= 85 is equal to Total number of grades (All A's or B's)
       Display "Honors" if student qualifies
L - Checks for High Honor roll using formula: E=0 AND F>=5 AND G=H
       E=0 - Has no "Exclude from Honor Roll" Flags checked
       F>=5 - Taking at least 5 courses
       G=H - Number of grades >= 93 is equal to Total number of grades (All A's)
       Display "High Honors" if student qualifies

You can also specify text to be printed if the condition is false.  In this example we want to print D-N-Q (Does Not Qualify) when the student does not qualify for the particular honor roll.

You can surpress the printing of either those records that meet the criteria or those that do not by using "{Hide}" or "{HideLine}" in the text fields.  In this example we want to print out students who are not elligible to participate in extra-curricular activities.  In order to participate students must be passing 5 courses and have an Average of 70 or above.

The data exported from PowerSchool contains Student name, Course Number, Course Name, Percent, Credits, Credits, Percent, Grade, and Percent.

Columns E & F are used to count the number of courses the student is passing. Columns G & H are used to calculate the weighted average. Column I is used to count the Incompletes.  Finally Column J determines if the student is ineligible.  The text "Ineligible" is printed for those students.  Students who are eligible are not printed at all. The text "{Hide}" is used to surpress the printing of the eligible students. Note also that some columns do not appear in the final report because of the check in the "Hide" check box.

Ignore

"Ignore" can be used to keep a column in a report but leave the column blank in the summary row.  This is handy when you want to see the data in detail lines but not in the summary row.  In the Honor Roll example above, Course Name and Teacher Name have the "Ignore" parameter.  In the sample below the Course has the "Ignore" parameter.  To completely remove the column from the report used the "Hide" check box.

RevBreak

"RevBreak" does the same thing as "Break" except the content of the cell on the summary row is reversed at the comma.  This parameter was designed to work with the PowerSchool field LastFirst but could be used with any data containing a comma.

RevDisplay

"RevDisplay" does the same thing as "Display" except the content of the cell on the summary row is reversed at the comma.  This parameter was designed to work with the PowerSchool field LastFirst but could be used with any data containing a comma.

RevGroup

"RevGroup" does the same thing as "Group" except the content of the cell on the summary row is reversed at the comma.  This parameter was designed to work with the PowerSchool field LastFirst but could be used with any data containing a comma.

Sum all
There are two "Sum" parameters: "Sum all" and "Sum numeric".  "Sum All" adds up the numbers in rows regardless of their value whereas "Sum numeric" sums only numbers meeting certain conditions. Additional conditions can be imposed on the sum parameters when using "Sum numeric".  In the example below, Column B sums all the numbers, Column C sums all the numbers less than 93, and Column D sums all the numbers 85 or above.

Weighted Average

This parameter calculates a "Weighted Average".  The current column must contain the data to be averaged, most often it is the field "Percent".  The column immediately to the left must contain the weights, most often it is the field "Credits".