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...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    It seems that you may use RANKX Function to add a calculated column.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    Anonymous,

     

    It seems that you may use RANKX Function to add a calculated column.