Convert two tenure columns into one (Year Month into Months)

user07818
user07818 Member
edited March 2023 in Datasets

Hi i have two columns that are year and month. I want to combine the two columns to show months. Ie Year column =1 Month Column=2, that equals 14months. Or i can combine the columns into one so the tenure is 1.2 years...but i want it displayed in months. Can anyone help?

 

thanks

Paolo

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    If you have a column for years and a separate one for months, you could create a BeastMode at the card level that went something like this:

    (`Year` * 12) + `Month`

    That would give you a total count of months for the row in question. 

     

    Let me know if you have any other questions on how to do this.

     

    Sincerely,
    ValiantSpur

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    If you have a column for years and a separate one for months, you could create a BeastMode at the card level that went something like this:

    (`Year` * 12) + `Month`

    That would give you a total count of months for the row in question. 

     

    Let me know if you have any other questions on how to do this.

     

    Sincerely,
    ValiantSpur

  • perfect thanks!