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.
SOLVED

Formula tool calculation error

MHS
8 - Asteroid

Hello Community!

 

I am having an issue with the formula tool that I am unable to figure out and hoping that someone can help point out what is happening with my calculation.  I am attempting to add up the values from 4 prior multi-row formula tools to arrive at a sum, but Alteryx is calculating the values that are much larger than the sum of the pieces.  

 

MHS_0-1655385653617.png

 

The values for the open status duration, sprint ready duration, 3 amigos duration, and in progress duration are 6126481, 6126481, 0, 0 which adds up to 29758628.  The total story duration tool is providing me with a total value of 612648123632147?!  

 

MHS_1-1655386528173.png

 

For the life of me I cannot determine what is happening with the calculation and I am sure it is something simple that I am overlooking.  Any help with what is occurring would be greatly appreciated.  

 

Thanks, 

 

Matt

10 REPLIES 10
Qiu
21 - Polaris
21 - Polaris

@MHS 
That will do it.
I personally sometimes confused with 0 or 1 stands for True or False, my bad, hehe.


So I always try to avoid to use 0 or 1 for boolean value. 😁

Labels
Top Solution Authors