- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 02, 2024 01:40 AM
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Aug 02, 2024 01:40 AM
Thank You! It worked.
