Help

Error in formula with 2 or more elements.

Topic Labels: Formulas
Solved
Jump to Solution
468 2
cancel
Showing results for 
Search instead for 
Did you mean: 
javisantacata
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

error formula.jpg

2 Solutions

Accepted Solutions

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:

Pascal_Gallais_0-1722586164546.png

 

Regards,

Pascal

See Solution in Thread

javisantacata
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank You! It worked.

See Solution in Thread

2 Replies 2

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:

Pascal_Gallais_0-1722586164546.png

 

Regards,

Pascal

javisantacata
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank You! It worked.