Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Voska
8 - Asteroid

Hello,

Can someone please explain why Alteryx math seems off?

image.png

4 REPLIES 4
jrgo
14 - Magnetar

@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.

Voska
8 - 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!

MSalvage
11 - 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

 

 

jrgo
14 - Magnetar

@Voska,

 

Illustration of decimal precisionIllustration of decimal precision 

Hope this helps!

Labels