Skip to main content
  • EN

Hey everyone, I'm getting used to FME and needed some help with a task that I wanted to complete. I have an excel sheet that has the total produced oil, water, and gas for a month at a time per column. Each row represents one year of a well. I tried using the doing the StatisiticsCalculator and Im getting the cumulative sum but I just want one final sum for each well. I have production data going back to the 80s so the running cumulative is way to many rows. Does anyone know how I can get the total sum for each well?

Hi @fme_noob,

Thanks to share us your case and png file.

It's posible to share us the xls file, just sample data?

Thanks,

Danilo

StatisticsCalculator is the way to go.

But use: Group by product.

And then use the Summary output port.

That should work.

Reply


Community Stats

30,162
Posts
114,480
Replies
37,807
Members
Terms & ConditionsCookie settings
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.