3 Replies Latest reply on Mar 1, 2018 7:34 AM by Joe Oppelt

    How can I reduce a fraction to its lowest / simplest form in Tableau?

    justin.nathan.1

      ”To reduce a fraction to lowest terms (also called its simplest form), divide both the numerator and denominator by the Greatest Common Denominator. For example, 2/3 is in lowest form, but 4/6 is not in lowest form (the GCD of 4 and 6 is 2) and 4/6 can be expressed as 2/3.”

       

      I need to know if this calculation can be achieved within Tableau itself and if so, how would I do this?  An example would be great...if indeed this is possible.  If not then just knowing that it’s unachievable from within Tableau would be helpful all the same.

       

      Please let let me know if you have any questions.

       

      Much appreciated

       

      J