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?
Question
Find the Total Production (total sum) with 40 years of monthly data.
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.
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.
+51- Celebrity
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
+22- Contributor
StatisticsCalculator is the way to go.
But use: Group by product.
And then use the Summary output port.
That should work.