Grooper 21.00.0082 is available as of 12-12-2023! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.00.0044 is available as of 06-20-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0026 is available as of 09-16-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 24.0.0012 is available as of 10-10-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Calculation using a field that is not a sibling
ptomko
Posts: 68 ✭✭
Payment Calculations Totals table always only has one row and it captures what should balance to the total of the First Period and Second Period in the Payment Calculation Table. I set it up as a Table rather than extractors so it will look better and line up with the other table columns on screen.
Is there a way to validate that the First Period in Payment Calculation Totals equals the sum of the First Period in the Payment Calculation Table?
Here is what the section looks like in Data Review with the formatting of the totals line as a table.
Tagged:
0
Best Answer
-
The Chuck Posts: 81 modThis was a bug and will be resolved starting with Grooper 2.70.0017.
In your total data column, you will be able to write the following Calculate Expression:
SumFieldInstance(<NameOrId>)
Where "NameOrId" is either the GUID ID of the target field or the full path from the data model to the field name (e.g. "Payment Section\Payment Calculation Table\First Period").8