Calcular la diferencia entre 2 columnas

1. Columna “DIFERENCIA”

• Debe calcular automáticamente la resta NUEVO – ACTUAL; en el ejemplo: 1500-1200 = 300

Hi AUTONORT_TRUJILLO_SAC,

In order to calculate the result of Nuevo minus Actual for each row, you'll need to add one condition for each row. Let me show you how to add a condition like this for one row:

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.

4. Create an Update/Calculate Field condition.

5. Set up your condition like this:

6. If you need, here's a screencast for adding the calculation itself:

That's it for the first row. But then this would need to be repeated for the rest of the rows as well, creating one condition per row in your Input Table.

Let us know if you have any other questions.

Muchas gracias.