Hi there, I have come across what I believe to be a bug with the summarise tool where if the result of the sum is shorter in length than the maximum length in the input, there will be leading zeroes on the result.
I have attached a simple example below where we sum 1000001.00 and -1000000, where we get a result of 0000001.00. This is all with FixedDecimal 19.2 but I have replicated on other sizes.
The issue I found with this is that if we then try to join the 0000001.00 onto a 1.00, it fails to join.
I have found a workaround where you add a cleanse tool with Replace with 0 (Numeric fields), or simply multiply the result by 1 and it returns 1.00. This means for every summarise tool I would need to add this extra tool.
I believe this is a bug as when you do the same calculation in a formula tool, you get 1.00 as expected
I changed to FixedDecimal across my large workflow as I am joining a lot of numbers together and I didn't want to risk the joining of doubles.
I hope this gets fixed soon as it seems like something rather important.
Thanks,
Michael
