Jump to content

jbj500

Members
  • Posts

    2
  • Joined

  • Last visited

jbj500's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. jbj500

    Weighted Average

    In excel I would do sumproduct(VOLUME, PRICE) / sum(VOLUME).
  2. jbj500

    Weighted Average

    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.
×
×
  • Create New...