Question

Find the Total Production (total sum) with 40 years of monthly data.

F

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?

2 replies

danilo_fme
Rank
Userlevel 4
Badge +30

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

erik_jan
Rank
Userlevel 2
Badge +16

StatisticsCalculator is the way to go.

But use: Group by product.

And then use the Summary output port.

That should work.

Reply


Community Stats

28,706
Posts
109,463
Replies
36,551
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.