Average of negative/positive numbers in list

[telaholcomb]

Hey hey! I am trying to get the average of the negative or positive numbers (conditional) in a list.

I was trying to follow the feedback here from @romanmg but I think I’m missing something.

Count only negative or positive results

So sorry this got by me… So what is the source of this list? If the source of your list is a Search for Grades and you have a field called “Score” that is a number within the Grade type… To extract positives, you could use a text element for this expression: “Repeating Group’s list of Grades :filtered :count” where the filter is Score > 0 Do < 0 for negatives. You could also do a database search with the same source as the Repeating Group. “Search for Grades: Count” where the search has the …

Here's what I have: https://www.loom.com/share/31547ec469ab46b5bb89e4959ef8d91b

[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]

[telaholcomb]

Thanks, @SerPounce! BDK’s RepeatingGroup Tool did the trick!