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
18 - Pollux

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

Labels