Average of negative/positive numbers in list

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.

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

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:

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

This topic was automatically closed after 70 days. New replies are no longer allowed.