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

user07818

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

BlueRooster

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

BlueRooster

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

Unknown

perfect thanks!