Skip to main content
  • EN

Hi,

Is there a way of being able to replicate excel's sumifs/Averageifs functions in FME?

I have two tables, the first table has unique ID's and the second table contains data which I need to aggregate. Is there a transformer where I can use the unique values in table 1 to match against the data in table 2 to perform a Sumifs?

Thanks in advance.

Hello, yes you can use the 'group by' function on the statistics calculator. Might need to join your tables, although not clear on that from your post. Owen

Thanks for your help!

Community Stats

31,951
Posts
121,336
Replies
39,562
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility 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.