Hi,
I'm new to FlexiCapture and haven't been able to work out how to calculate the sum of the line item amounts from repeating groups of table values. The tables are spread across multiple pages and I'm capturing the required amount from each table (e.g. total vehicle fuel cost where each table consists of the costs per individual vehicle with 40+ tables (vehicle amounts) in a single document), but I need to be able to calculate the total amount from all the tables so that I can configure a rule to check that the combined totals match the invoice total. Can someone please advise how best to achieve this?
Thanks,
Mike
Comments
2 comments
Hello,
You may use the “Calculate sum” validation rule (see Program settings > Document Definitions > Rule validation > Calculate Sum rule in the Administrator guide)
Thank you Ekaterina, I had seen that but didn't realise it applied to repeating groups/tables, I'll check that out.
Please sign in to leave a comment.