3.1. Create Table - Single Table Selection
3.2. Create Table - Multiple Tables Selection
3.4. Export & Email Table
3.3.2 Customise Table – Compute Functions
This function allows you to apply computation functions to the data points of the data table created.
You can compute new data values by using any of the functions below:

 step1
Summation

Step 1 of 5
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 5
In the dropdown menu, click on summation
.

Note:The Summation option will be greyed out if this function is not available for use in the table created.

Step 3 of 5
The Summation pop-up screen will be displayed. Choose variables for summation by holding down Shift or Ctrl and clicking on the appropriate variables/time periods in the pop-up screen. You can choose to sum either 2 or more row variables, or 2 or more column variables.

Step 4 of 5
Input name for the new variable.

Step 5 of 5
Click on OK to compute.
sum1

A new row variable will be appended at the bottom of the data table, while a new column variable will be appended to the right of the data table.
Screenshot_10 Back to top
Subtraction

Step 1 of 6
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 6
In the dropdown menu, click on subtract

Note: The subtraction option will be greyed out if this function is not available for use in the table created.

Step 3 of 6
The Subtraction popup will be displayed. Choose minuend* and subtrahend(s)*. You can include more than one subtrahend by clicking on the Add Subtrahend button. To remove a subtrahend, click the Remove hyperlink to the right of the subtrahend you wish to remove.

*In an equation, A – B =C
A is referred to as the minuend
B is referred to as the subtrahend

Step 4 of 6
Input name for new variable.
Screenshot_11

Step 5 of 6
To avoid selecting the same variable more than once in the computation, check Disallow duplicated variables.

Step 6 of 6
Click on OK to compute.

The new variable will be appended at the bottom of the data table.

Screenshot_12 Back to top
Multiplication

Step 1 of 5
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 5
In the dropdown menu, click on multi

Note: The multiplication option will be greyed out if this function is not available for use in the table created.

Step 3 of 5
The Multiplication pop-up screen will be displayed. Choose variables for multiplication by holding down Shift or Ctrl and clicking on the appropriate variables/time periods in the pop-up screen. You can choose to multiply either 2 or more row variables, or 2 or more column variables.

Step 4 of 5
Input name for new variable.

Step 5 of 5
Click on OK to compute.
Screenshot_13

A new row variable will be appended at the bottom of the data table, while a new column variable will be appended to the right of the data table.
Screenshot_14
Back to top
Division

Step 1 of 6
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 6
In the dropdown menu, click on division

Note: The division option will be greyed out if this function is not available for use in the table created.

Step 3 of 6
The Division pop-up screen will be displayed. Choose dividend* and divisor(s)*. You can include more than one divisor by clicking on Add Divisor. To remove a divisor, click the Remove hyperlink to the right of the divisor you wish to remove.

* In an equation, A/B = C
A is referred to as the Dividend
B is referred to as the Divisor

Step 4 of 6
Input name for new variable.
Screenshot_15

Step 5 of 6
To avoid selecting the same variables more than once, check Disallow duplicated variables.

Step 6 of 6
Click on OK to compute.
The new variable will be appended at the bottom of the data table.
Screenshot_16
Back to top
Division by 10N

Step 1 of 6
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 6
In the dropdown menu, click on Division10

Note: The division by 10N pop-up screen will be greyed out if this function is not available for use in the table created.

Step 3 of 6
The Division by 10N popup will be displayed. Choose at least 1 variable by checking the checkbox to the left of the variable name. To select all variables, check the checkbox at the top left–hand corner of the table.

Step 4 of 6
Select the input value of N from drop down menu.

Step 5 of 6
Input the appropriate Unit of Measurement for the variable(s) after the function is applied to the series.
  • Edit the description for the unit of measurement in the textbox next to any variable in the table. The unit of measurement of the remaining variables with the same unit of measurement will be updated with the description that you enter.
  • If the variables have different units of measurement, edit the description for the unit of measurement in the text box next to any variable in the table. The other variables of the same unit of measurement will be updated with the description that you enter. You may repeat this step for another variable with a different unit of measurement.
Step 6 of 6
Click on OK to proceed.

Screenshot_17

If the unit of measurement is not updated, the system will prompt you to change it. Click on OK to update unit of measurement, or Cancel if you do not wish to proceed.

Screenshot_18

The system will check if you wish to perform another Division by 10N function. Click Yes to perform another function or No to cancel.

Screenshot_19

The new variables will be shown in the table. To view the original table, check on the checkbox Show original values above the data table.

Screenshot_20
Back to top
Convert Value to Percentage

Step 1 of 4
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 4
In the dropdown menu, click on Screenshot_42

Step 3 of 4
The Convert Value to Percentage popup will be displayed. Choose the type of computation you wish to perform:
  • Percentage by row
  • Percentage by column
  • Percentage by total

Screenshot_21

For Percentage by row, all observation values in the same row will be selected as a default for conversion to percentage. You may select the rows and columns for conversion. The percentages will be calculated using the summation of selected data points in each row as the denominator.

For Percentage by column, all the observation values in the same column will be selected as a default for conversion to percentage. You may select the rows and columns for conversion. The percentages will be calculated using the summation of selected data points in each column as the denominator.

For Percentage by total, you may select any rows and columns for conversion to percentage. The percentages will be calculated using the summation of all the selected data points as the denominator.

Step 4 of 4
Click OK to compute.

The new percentage values will be shown in the table. To view the original table, check on the checkbox Show original values above the data table.
Screenshot_22
Back to top
Compute Percentage Change

Step 1 of 4
In the Table Customisation and Chart Plotting page, click on the Compute menu.

Step 2 of 4
In the dropdown menu, click on computePercentage

Note: The Compute Percentage Change option will be greyed out if this function is not available for use in the table created.

Step 3 of 4
The Compute Percentage Change popup will be displayed. Choose the type of computation you wish to perform:
  • Period on Period (e.g. Month on Month)
  • Year on Year
Percentage changes may be computed based on period by period (e.g. May 2016 as compared to Apr 2016, 2Q2016 as compared to 1Q2016) or year on year (e.g. May 2016 as compared to May 2015 or 2Q2016 as compared to 2Q2016).

Period on Period Percentage Change

Screenshot_23

Year on Year Percentage Change

Screenshot_24

Note: The computed percentage change data are based on the level of precision of the data in the table (e.g. data are in 1 decimal place) and may differ slightly from those found in published source (e.g. which may be computed based on data in 3 decimal places).

Step 4 of 4
Click OK to compute.

The period on period or year on year percentage table will be displayed. To view the original table, please check on the checkbox Show original values above the data table.

Back to top