Advanced Function - Weighted Average
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])
Replies have been locked on this page!