Advanced Data Table - Total Row Validation on dynamic advanced data table sections
Often times clients want to enforce a minimum or maximum amounts on certain columns such as request amount or match amount on an advanced data table total row. This currently isn't possible without passing the data to a static section. This makes validation tedious and time consuming to configure, but also more complicated for a client to edit and update later.
One should be able to use validation in the amounts in the total row only such as:
-Comparing the amount in one column to a field on the grant or linked cycle
-Comparing the amount in one total column to another on the same section
-Comparing the amount in one total column to another in a different section
