Sum value into foreach in flow designer

Paolo
Kilo Explorer

Hello.

I need to help.

I have two tables.

The first table is "Movement" and the second table is "RowMovement", the first table is referenced in the second table.
Movement has a column "total", this value is the sum of column "amount" in "RowMovement".

With flow designer I have a trigger that

  1. update or create "RowMovement"
  2. update total = 0;
  3. Lookup records RowMovement where movement.sys_id = RowMovement .movement.sys_id
  4. in foreach
  5. update RowMovement .Movement 
  6. in scripts: return parseFloat(fd_data._3__foreach.item.u_amount) + parseFloat(fd_data._3__per_ogni.item.u_movement.u_total)

Now if i check it with test button it works, but at runtime it not works.

Why????

Thank you.

2 REPLIES 2

Community Alums
Not applicable

Can you please provide screen shots of your code / buttons, so we can help.

Paolo
Kilo Explorer

The screenshot with italian translation.

Rimborso is RowMovement
NotaSpesa is Movement.

Thanks.

find_real_file.png