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.0042 is available as of 03-22-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Grooper 23.1.0018 is available as of 04-15-2024! Check the Downloads Discussion for the release notes and to get the latest version.
Options
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
-
Options
The Chuck
Posts: 81 mod
This 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