Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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