Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Thank you Aron..that was perfect
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
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.
Aron,
That was a perfect solution.
Thanks
B