Average of negative/positive numbers in list

[SerPounce]

I don’t think you can reference the RG’s data directly for numerical expressions (or any other purpose). You will need to do a search for the same criteria as the data source for the RG. You can also user plug ins like list shifter or BDK’s RG utilities. Or you can try and get this to work for your needs:

Calculating grand totals in repeating group

Here is the solution using custom states and the hack I was thinking of. There is a fair amount of custom state jiggery pokery going on and I use a custom event that is triggered for the count of rows in the RG to add each transaction to the Grand Total custom state. Let me know if you have any questions. [Screen Shot 2020-07-10 at 5.18.46 AM]