Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Alteryx rounding

saivig99
6 - Meteoroid

Hi All, 

 

I have a calculation in my tool that is currently calculated in Alteryx, while I was reviewing the data I found that when I re-calculate the number is excel it is different from the Alteryx calculation . Although they are close they do not match. Please find below the details on the calculations- I tried every possible way to tweak both Alteryx and excel and I am not able to match them. 

 

Data:

 

X1X2X3X4C1(Alteryx)Excel
0.009563750.1525.079999193525.147058015

 

 

Formula:

 

Step 1: ROUND(X3/(1-X4),5)

Step 2:  ( Step 1 ) * ( X1 *X2 )

 

Thanks

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
Round([X3]/(1-[X4]),.00001) * ([X1]*[X2])

The round statement should be to the decimal place.

 

This results in:  25.14705879

 

with .00001, the result is:     25.1470605

with .0000001, the result is: 25.147058847

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
ThizViz
11 - Bolide
Looks like Mark's gotcha covered.

Just in case this doesn't resolve it, for anyone else reading, make sure you convert nulls to 0 in Alteryx as that could also throw off your totals and make them inconsistent with Excel results.
@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Labels