Skip to main content
Solved

Error in formula with 2 or more elements.

  • August 2, 2024
  • 2 replies
  • 14 views

Forum|alt.badge.img+6

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?

Best answer by Pascal_Gallais-

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

2 replies

Pascal_Gallais-
Forum|alt.badge.img+21

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


Forum|alt.badge.img+6
  • Author
  • New Participant
  • August 2, 2024

Thank You! It worked.