We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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