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


e57a5bbe8711b340833ccabae2cd5ffd