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.
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?!
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
Solved! Go to Solution.
@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. 😁
User | Count |
---|---|
109 | |
89 | |
77 | |
54 | |
40 |