ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Output report total not accurate

itssumanb
8 - Asteroid

Hi team, 

I need help with something really weird that I noticed. In the attached workflow, the last calculation performed is using the formula tool. The Summarize tool, highlighted, shows the Sum of a "current" field as $100 (dummy number) however, when I run the workflow the report shows the total sum of the "current" field as $105. I mean, since there are no calculations performed following the formula tool and the summarize tool shows the correct/expected total amount, why is the output file total amount for that field is different )(higher)? I can't think of how/why this can happen. Any help is appreciated.

 

Thanks 

Suman

Capture_alt.JPG

11 REPLIES 11
itssumanb
8 - Asteroid

Re: datatype - it is Double throughout the workflow and the summarized tool also shows the sum as Double. 

apathetichell
20 - Arcturus

all weird. maybe it somehow rendered the percent sign as a 5...

Labels
Top Solution Authors