3 Table Functions
3.1. Create Table  Single Table Selection 3.2. Create Table  Multiple Tables Selection


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:


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 . 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 popup screen will be displayed. Choose variables for summation by holding down Shift or Ctrl and clicking on the appropriate variables/time periods in the popup 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. 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. 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 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. 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. 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 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 popup screen will be displayed. Choose variables for multiplication by holding down Shift or Ctrl and clicking on the appropriate variables/time periods in the popup 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. 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. 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 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 popup 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. 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. Back to top 

Division by 10^{N}
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 Note: The division by 10^{N} popup screen will be greyed out if this function is not available for use in the table created.
Step 3 of 6 The Division by 10^{N} 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.
Click on OK to proceed. 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. The system will check if you wish to perform another Division by 10^{N} function. Click Yes to perform another function or No to cancel. 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. 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 Step 3 of 4 The Convert Value to Percentage popup will be displayed. Choose the type of computation you wish to perform:
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. 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 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 Percentage Change Year on Year Percentage Change 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 

