Skip to main content
Question

Sumifs/Averageifs in FME


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.

2 replies

owen
Forum|alt.badge.img+1
  • August 3, 2018

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


  • Author
  • August 14, 2018

Thanks for your help!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings