Can Alteryx create a column with Fractional values?

Question

Hello,

I was wondering if anyone happened to know if it's possible to turn a column containing decimal values into fractional values in Alteryx?

I have a dataset with several hundred individuals. Each of these individuals owns units in a partnership which are represented as a % of the total partnership units. Unfortunately, the accounting software I'm using requires a numerator and denominator figure, hence the need for fractions!

Historically, I've taken the client data and converted it using Excel formulas which becomes my workflow starting point. In the attached example, you can see it's just the following formula: "=TEXT(C4/$C$22,"#/######")" followed by a quick =LEFT/=RIGHT to pull my numerator and denominator.

I was hoping to figure out how to get the fraction set up in Alteryx so I can integrate this external step into the workflow.

Thank you!

FractionExample.xlsx

T_Willins · Accepted Answer

Hi @TGow,

Is there a reason not to use the Units Held as the numerator and the total Units Held as the denominator?  Your Excel fraction formula rounds to the nearest millionth, so you can take the actual amounts, multiply by 100,000 and round to the nearest integer to get a fraction.  See attached.