Skip to content
Advertisement

Tag: weighted-average

Postgres Calculating Weighted Average

I am trying to get the weighted average of items from this example table: Item Value Item1 0.10 Item2 0.15 I followed this example here how to calculate it: https://www.wikihow.com/Calculate-Weighted-Average And tried this statement: I am trying to get the average by doing SUM(numberXWeightingFactor) but it doesn’t work. Ends up giving me error: column “numberxweightingfactor” does not exist. Answer Multiple

Advertisement