Advanced Function - Weighted Average

Nathan Schroeder shared this idea 2 years ago
Idea Logged

I would like to request an advanced function to make it easier to create % of total weighted averages.

In this example "Invoiced Amount" is being weighted by the count of "Athlete ID" over the "Month".

Weight = Inv Amount * Count ID(master query) / Count ID(sub-query [total for the month])