Modifying Report Columns

This is where you decide exactly what you need in the columns for your report. To access report columns, click the Columns tab within the Reports page. There is a number listed on the tab; this indicates how many columns are being used for the report.

You can modify the titles and select where the data will be pulled from based on the type of report it is. Column options are listed in a drop down menu for easy selection.

Once you have selected your column name and the type of column it is, click Add Column. This will place it at the bottom of the list of columns.

 

Comparison Columns

You may have noticed a dropdown for selecting the "type" of column. The secondary option, "Comparison," allows you two calculate the difference between two columns. 

Note that the values in the columns being compared have to either be both integers or dates.

After selecting "Comparison," you can choose the two other columns you'd like to compare. The second value will be subtracted from the first value. 

If a column with a date value is selected for either column, "Current Day" will become available in the other column. This can be used to compare any date to the present.

In this example, the comparison is between the Expiry Date of a material in a Location Content Breakdown report, to determine how long until the material expires.

Additionally, if date values are selected, you will be able to choose the unit of time for the calculation, from minutes to year. In this case, the comparison will calculate the number of days between the two values.

Once columns are created, you can then arrange and rearrange as needed by clicking on the cross arrow to the right and dragging the appropriate column where you would like it to be in the sequence.

If you have more columns than you need or added one in error, you can delete a column at any time by clicking on the trash can icon to the right.