This lesson will walk you through the basics of using Calculations within Custom Reports as well as providing suggestions on when to use this tool.

**Note:** This is a permission-based feature. Your district's system administrator can grant the permission for Calculations.

This lesson assumes you are working on a custom report. See the "**Create a Custom Report**" lesson if you require help.

To Add a Calculation to a created report:

1. Click the **Advanced** tab

2. Then press **Add a Calculation.**

In the Edit Calculations page, you can set up your desired calculations using the following symbols (*, /, -, +) for multiplication, division, subtraction and addition accordingly.

**NOTE:***If the calculation set up does not match the accepted notational form, you will receive the following error message **"*Your calculation has an error. Your changes were not saved. Calculations may only contain numbers, letters of the columns shown at the left, parentheses, spaces, and mathematical operators (+, -, *, and /). Your parentheses must also be balanced."

Calculations in Custom Reports are helpful for users interested in comparing student results on multiple benchmarks and state tests. The following scenario will address one way to create an average score column for a district benchmark and state test.

-Data columns added to this report include Student ID, Student First and Last Name, Benchmark 1, Benchmark 2, and State Assessment ELA.

- Click Advanced and then Add a Calculation. Once int the Edit Calculations page, **(1)** add a column name to this calculation. Once your calculation is complete, a new column will be created (using this supplied name) to show that calculation.

- Next, **(2)** locate the columns to be averaged. Using the letters associated with each column (i.e. **A** for **Benchmark 1**), create a mathematical function to produce the desired results. In this instance, since we are trying to find the average overall score for these assessments, we will need to add Benchmark 1, 2 and the State Assessment together and divide by three, as shown above.

-Once your calculation is complete, **(3) **click save.

After you have saved this calculation, you will be able to repeat these steps to create multiple calculations per report.

To return to a previously created calculation to make a change to it, go to the Manage Columns page, find the column in question and select Calculation. This will take you back to the original calculation input page. Make your edits and click **Save**. You will get a message saying 'Calculation Saved'.

To edit or change your calculations, visit **Manage Columns** in your reports taskbar. Select or click on the Calculation you wish to edit or change and it will take you back to the Calculation setup page.

To delete your calculation, select the **Delete** checkbox on the *Manage Columns* page. Select **Save Changes** to confirm.

## Next Steps

For any other information on creating Custom Reports, see the help chapter titled, 'Custom Reports'.

## Comments

5 comments

Having a true average function would make a huge difference for custom reports. They're very interesting and promising but as-is they pale in comparison to excel, google sheets, and other external report options. When will we see some resources dedicated to this portion of Illuminate? I want to use it more! =)

I would like an average function as well. My averaging isn't always accomplished through using the window column. I would also like to see some examples of formulas that can be used using this function.

I agree Brittany! I would love to see a dozen or more examples of this calculation feature as it is used in other districts. This section of the support documents seems incomplete with just a single example provided. Looks like for now it is limited to just simple mathematical notation (addition, subtraction,multiplication, division). But could be much more powerful, as Nicholas mentions.

Actually, you can do more than simple math, which makes the need to develop this section out even greater! I found this link: https://support.illuminateed.com/hc/en-us/community/posts/115000236234-Reporting-How-can-I-get-just-the-student-s-middle-initial-in-my-custom-report-

Which shows the use of an "excel" like feature "Substring" Who knew? :)

I'd also like to figure out how to calculate the following:

I have 3 data fields each with a value between 1 and 4. I want to set a conditional flag to "Met" if all 3 fields have a value greater than 2.

Is this possible with conditional columns?

Please sign in to leave a comment.