3.1. Create Table - Single Table Selection
3.2. Create Table - Multiple Tables Selection
  • 3.3. Customise Table
  • 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
    .

    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.
    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 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.


    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 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.


    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 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

    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.



    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 10N 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:
    • Percentage by row
    • Percentage by column
    • Percentage by total



    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 (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



    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
    Move to previous topic Previous Home Next Move to next topic