The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Aug 02, 2024 12:27 AM
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?
Solved! Go to Solution.
Aug 02, 2024 01:10 AM
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
Aug 02, 2024 01:40 AM
Aug 02, 2024 01:10 AM
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
Aug 02, 2024 01:40 AM
Thank You! It worked.