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