Alteryx Designer Desktop Discussions

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

Output - Inconsistent Data

gabrielmier222
7 - Meteor

Hi y'all, 

 

having an issue importing my output into SageIntacct.

I have a sum tool at the end of my workflow that validates my totals for Debits and Credits are the same amount.

I double checked my initial Alteryx and confirmed the amounts were correct, but after importing I get an error message that says my entry is off by a few cents and upon reopening the output file, the amounts have changed.

 

Has anyone experienced anything similar? Some guidance would be appreciated

thanks in advance friends

Snag_4814720c.png

 
1 REPLY 1
geraldo
13 - Pulsar

@gabrielmier222 

 

It will be better before exporting if you already export with rounding.

Round([Field], 0.01)
if 2 decimal places

Labels