Skip to main content
Question

I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups

  • July 14, 2021
  • 1 reply
  • 44 views
F
I am looking for a sumproduct like function in excel that i can use on data i have in FME. What i am really after is a weighted average of certain groups of data. I have the products solved for in separate fields but i can't sum within their groups.

1 reply

gazza
Contributor
Forum|alt.badge.img+6
  • gazzaContributor
  • Contributor
  • July 14, 2021

Use the StatisticsCalculator with the Group By set to the group attribute.

Community Stats

32,682
Posts
124,032
Replies
41,134
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.