To perform calculations in a table

You can use the sum function in FormCalc to total the values in a column. You must add the calculation to the footer row of the table.

  1. Select the cell in the footer row where you want the calculation. For example, select the cell that corresponds to the total for Q1.

  2. In the Script Editor, select Calculate from the Show list.

  3. In the Language list, select FormCalc.

  4. In the Run At list, select Client.

  5. In the Script Source field, insert your FormCalc calculation. For example, to calculate the total for the Q1 data, type the following expression:

    sum (Table.Row[*].Q1[*])
  6. Repeat for the totals for Q2 and Q3.

  7. To calculate the totals for the country, type the following expression:

    sum(Q1 + Q2 + Q3)
  8. Repeat for the remaining row totals.

  9. For the grand total, type the following expression:

    sum(TotalQ1 + TotalQ2 + TotalQ3)
    To show the data as 10K, in the Object palette, click the Cell tab, click Patterns, and type z9'K' in the Pattern box. In the Value tab, select Calculated - Read Only from the Type list.

// Ethnio survey code removed