John Brand Posted April 29, 2021 Share Posted April 29, 2021 I have monthly production data for a bunch of wells. Each record in the monthly production data includes the 'flow month' (1,2,...,49,50, etc). How can I write an expression to sum only the first 10 months of production and then divide it by 300 for each well Link to comment Share on other sites More sharing options...
Fabian Duerr Posted April 29, 2021 Share Posted April 29, 2021 You can do this in two steps. My example shows this for the last two months only. Please let me know when your data structure is different: First column [FirstTwoMonth]: (for two month the condition is < 3 or Link to comment Share on other sites More sharing options...
John Brand Posted April 29, 2021 Author Share Posted April 29, 2021 Thanks Fabd! Do you know if it's possible to calculate the same thing using a custom expression in a cross table Basically performing the calculation without having to add calculated columns to the data table Link to comment Share on other sites More sharing options...
Fabian Duerr Posted May 1, 2021 Share Posted May 1, 2021 Yes, this should be pretty easy. Just create your regular cross table. And then in the properties under data you can add a data limiting expression. This is always a boolean expression that evaluates to TRUE or FALSE. In my example above "[FLOWMONTH] <3" should do the job. Link to comment Share on other sites More sharing options...
John Brand Posted May 3, 2021 Author Share Posted May 3, 2021 Thanks again! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now