Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Error in formula with 2 or more elements.

Topic Labels: Formulas
Solved
Jump to Solution
626 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
Pascal_Gallais-
9 - Sun
9 - Sun

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
Pascal_Gallais-
9 - Sun
9 - Sun

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.