This content has been marked as final. Show 1 reply
I have a particular Dimension field that is a varchar in SQL and has various types of data values. I've pretty much figured out how to convert everything except for the decimal values to fractions. Which I will need for one of my charts that measure size in inches. The folks that did the data entry in the past entered it all in as fractions (ex: 3 3/16, 1 2/5); then they changed up their format to decimals (ex: 3.8175). I found a way to convert those fractions to decimals but have been unsuccessful in the reverse converting decimals to fractions. I need to display both the decimal and fraction in the Detail to cover both ways they've entered the data. Is this possible? Thanks in advance for the assistance.