Search the Community
Showing results for tags 'aggregate calculated field'.
Hello, I have fields VOLUME and PRICE; and a calculated field GROSS_PROCEEDS ([@field:VOLUME] * [@field:PRICE]). I need to figure out the weighted average price across all records (also across subgroups of records based on conditions associated with other fields). I've tried creating a formula in a new aggregate element but no luck. Any help would be appreciated.