Designer Desktop values are correct by Server values are slightly off

Question

As per the title. I’m not sure what’s going on exactly.

For example, Designer shows a value of 193.34, but Server shows 195.44 for some reason - this affects certain rows of data only. Not sure why.

My Designer Desktop version is still at 2021, the Server is at 2022.

Could it be an impact of decimal places with error carried forward (ECF)? Or the server version differences causes it?

Anyone been through anything similar with advice?

fmvizcaino · Answer

I would go row by row and tool by tool to check where exactly this is happening. It could be something we are not aware of the version mismatch.

caltang · Answer

Thanks for mentioning this! I tried a little experiment with turning AMP on/off, and I get different results still.

Any other way to troubleshoot better? Aiming in the dark here...

fmvizcaino · Answer

Hey @caltang ,

I remember seeing a similar problem on version 23.1 where numbers close to 0 became huge. But I do think this is an isolate issue that will be fixed sooner rather than later.

One thing to look at is the floating-point error. If you have double data types and know the number of decimal places, try rounding them specially if they are being used in filter tools.

https://community.alteryx.com/t5/Engine-Works/The-Floating-Point-Number-Problem/ba-p/1135898

Best,

Fernando Vizcaino