Alteryx rounding

[saivig99]

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:

X1	X2	X3	X4	C1(Alteryx)	Excel
0.0095	6	375	0.15	25.0799991935	25.147058015

Formula:

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

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

Thanks

[MarqueeCrew · Accepted solution]

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

[ThizViz]

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.