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
  • 24 views

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
  • Contributor
  • 132 replies
  • July 14, 2021

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