1 Reply Latest reply on Aug 6, 2018 5:14 PM by Shinichiro Murakami

    Calculated Field to Convert Decimal to Fraction

    Donald Counts

      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.