Difference between Formula configuration data preview amount and actual output

[wonka1234]

Hi,

does anyone know why I get a different in my configuration formula data preview and my actual output?

[DataNath · Accepted solution]

Hey @wonka1234, I remember seeing a forum post about this where the issue was due to data types upstream. Are all of the fields used here doubles? I believe Alteryx previews the output as if they are. If not, it may be worth trying to make them so, and apply any necessary rounding in your final output (I.e. this equation if it needs to be a fixed decimal, or even use the round() function).

Thread here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Formula-Preview-Correct-but-actual-out...