Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

How to normalize months

Hi, 

 

I have a question which I would think has an easy answer. I have well production by month and I want to create a new column that normalizes month. For example, I want the first month of well production to be 1 instead of 9/30/2017 as in the example below. How can I do this? 

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    I should add to this that the next value in the column is a new well, so the equation would need to reset and normalize the months, starting with month 1 for 2/28/15 on PROPNUM 153768

  • Anonymous's avatar
    Anonymous
    Not applicable

    I should add to this that the next value in the column is a new well, so the equation would need to reset and normalize the months, starting with month 1 for 2/28/15 on PROPNUM 153768