How to convert 0.25 to 3 months and 0.75 to 9 months?

[Anonymous]

Hello fellow developers,

I have a list box contaoning values like 0.25,0.75,1,1.50 ....etc they represent years.

I want to display 3 months instead of 0.25

                        6 months instead of 0.50....1 year 6 months instead of 1.50..

How can this be done.

Thanks

B

[Anonymous · Accepted solution]

Don't know if this is the MOST elegant way, but a calculated dimension with something like this:

=FLOOR(Period) & ' Years ' & (Period - FLOOR(Period))*12 & ' Months'

That should do the trick.

[Anonymous]

Thank you Aron..that was perfect

[Anonymous]

For some reason I'm not able to sort the result in ascending or descending order...I want to sort it in ascending order..any suggestions

[Anonymous]

So leave the calculated dimension alone.  Go to the Sort tab and check "Expression".  In the edit box use whatever your field name is (I used "Period" in my example). 

=Period

Then you can select Ascending or Descending.

Hope that helps.

[Anonymous]

Aron,

That was a  perfect solution.

Thanks

B