Not working - Decimal Sum 10s

[JDong]

Hi Team,

I have the following data sample in my column 

Value

5,25

7,12

1,08

0,42

0,08

3,13

I want to add all these and create a subtotal. I have attached a sample flow in this email where the sample works fine.

I am applying this in my real world scenario and it does not work as expected. 

Instead the summation values are shown rounded off to nearest number or as 0

On trying to debug I am not able to figure out why this is happening since both seems to be using same logic. Any idea to identify the root cause ? End result should be the subtotal as attached.

Thanks

[apathetichell]

One quick thing:

Do you have "change output type" to "double" selected in your multi-field formula? your formula is correct and it should be flagging errors - but sometimes I forget to actually click on "change output type" as well.

[JDong]

@apathetichell 

Thanks. Yes I did change it to double but the result shows as 0 and not summing as expected.

One more thing from the tracing

The values are fine until this filter as shown below

In the next select tool I am converting the values to double so I can add the value in the summerize step

and that is where the values become like below.

If I convert field to FixedDecimal all values become like below

Seems trivial but not able to get over this issue.

[danilang · Accepted solution]

Hi @JDong 

The top Select tool is having problems with the commas in your numbers.  Copy the Multi Field tool that you have before the bottom Summarization and paste it before the top Summarization tool.  Make sure all the affected fields are selected in the multi field.  Then remove top Select tool

Dan

[apathetichell]

Also - when you convert to fixed decimal/fixed width using a select and you don't provide enough digits in your fixed width conversion for your number you get a nul(). use Double/not fixed width - unless you are 100% sure you are accounting for all of the digits.

[JDong]

And that worked 😀

Had I known that only the red step had to be replaced with multirow 😂

Thanks and it is pulling the values fine now...phew was a difficult one to spot for me....much appreciate your help @danilang @apathetichell