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?

”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

• ###### 1. Re: How can I reduce a fraction to its lowest / simplest form in Tableau?

Seems to me you would need a looping construct, which Tableau doesn't do.

But I can say this:

IF ( INT([A]/[B])*[B] ) = ([A]/[B])*[B]

then [B] is a valid divisor.

What you would do with that ... I'm not sure.  You need to run a loop to test that for all values of [B] from 1 through [A] to get all the possible divisors of [A].

1 of 1 people found this helpful
• ###### 2. Re: How can I reduce a fraction to its lowest / simplest form in Tableau?

Thanks, Joe.

Sounds like a useful feature that Tableau could develop in the future but for now I’ll just have to move on and find another solution for this.

• ###### 3. Re: How can I reduce a fraction to its lowest / simplest form in Tableau?

Lots of programming constructs would be useful, but Tableau isn't really written to be a programming tool.

There is an IDEAS forum (  here:  Ideas  ) where people propose ideas and others can vote them up or down.  I have voted up some threads on looping capabilities.  Search around in there and add your voice to ideas you like.