cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Why am i getting different results doing almost the same thing?

SOLVED
Highlighted
Asteroid

Hello,

Can someone please explain why Alteryx math seems off?

image.png

Alteryx Certified Partner

@Voska,

 

My guess is that it's because you're not including the additional precision your [calc] expression is generating. The result preview is rounding for clarity.

Asteroid

I don't think i am actual familiar with what you described, can you provide an example of precision setting you are referring to?  Thank you!

Bolide

@Voska,

 

Pretty sure it is because Alteryx visually rounds to 6 decimal places. Meaning it shows 0.032877, but the true value retained in the [calc] might be 0.032876711038961038961038961033896 = 10.126027/308.

 

Hope this makes sense,

MSalvage

 

 

Alteryx Certified Partner

@Voska,

 

image.pngIllustration of decimal precision 

Hope this helps!