Skip to main content
Question

Sumifs/Averageifs in FME

  • August 3, 2018
  • 2 replies
  • 51 views
E

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

owen
Forum|alt.badge.img+1
  • owen
  • 156 replies
  • 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

E
  • em2786
  • Author
  • 2 replies
  • August 14, 2018

Thanks for your help!

Community Stats

32,084
Posts
121,841
Replies
39,724
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.