Calcular el total por columna

  • AUTONORT_TRUJILLO_SAC
    Fecha de consulta 5 de julio de 2025, 16:41
    1. Fila “TOTAL REMUNERACIÓN” (última)
    • Debe ser la sumatoria de todas las filas anteriores .
  • Lars_L
    Fecha de respuesta 5 de julio de 2025, 17:52

    Hi AUTONORT_TRUJILLO_SAC,

    In order to calculate the total of each column and show it on the last row, you need to add 3 conditions. Let me show you how to add these:

    1. In Form Builder, in the orange navigation bar at the top, click on Settings.

    2. In the menu on the left, click on Conditions.

    3. Click on Add Condition.

    Calcular el total por columna Image 1 Screenshot 50

    4. Create an Update/Calculate Field condition.

    Calcular el total por columna Image 2 Screenshot 61

    5. Start by setting your condition like this:

    Calcular el total por columna Image 3 Screenshot 72

    6. Add all the cells of the Input Table from the column using the Add Field button.

    7. Add a Plus sign between each option in the calculation.

    8. Click on the Save.

    Calcular el total por columna Image 4 Screenshot 83

    That's it for the first column. You can repeat these same steps but selecting the fields of the second and third column instead to create the next 2 conditions.

    Let us know if you have any other questions.

  • AUTONORT_TRUJILLO_SAC
    Fecha de respuesta 8 de julio de 2025, 9:28

    muchas gracias

Your Reply