Error in formula with 2 or more elements.

[javisantacata]

When applying this formula "{Pago a realizar}-{Pago efectuado}"  to the selected fields, as you can see in the 4 file, the result is not 0 but 1. How could I fix this error?

[Pascal_Gallais- · Accepted solution]

Hello,

I guess that is because your lookup field "pago a realisar" contains 2 values in line 4.

If it is indeed possible that a single line can be linked to more than one "Referencia", then you field "Pago a realisar" should be a "rollup field" using the "sum(values)" computation:

Regards,

Pascal

[javisantacata · Accepted solution]

Thank You! It worked.