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

SubTot.yxmd

Datasets

Developer Tools

Data Investigation

Accepted answers

danilang

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

All comments

kelsey_kincaid

@JDong ,

Does the data look OK before going into the Summarize tool or is it rounded off to zeroes before then? Have you double-checked your Select tool to make sure your 'Value' field is set to a FixedDecimal and not an integer?

apathetichell

Do you have user settings/localization on comma for decimal? If so - you shouldn't need to do a tonumber() conversion.

I also wouldn't use the same column name for my conversion and instead create a new fixed with or double (preferably) column and use that for sums, or I'd use a multi-field formula to change the field-type and tonumber() in the same tool.

Basically you're taking in a comma for decimal number, putting that in a tonumber() formula but then back into a string field and then using select to transfer that to fixed with - if something has too many decimals or other oddities there could be an issue on the forced number to string and then subsequent string to fixed-with conversion

modified subtot.yxmd

JDong

@apathetichell @kelsey_kincaid

Thanks already for the support

Level	Value
5.100	0.000000
5.110	0.720000
5.120	0.170000
5.130	0.030000
5.140	0.190000
5.150	0.120000
5.160	0.000000
5.170	0.140000
5.180	0.000000

The first line output must be 1.37

Here is what is happening with my dataset. The top level is 5.100 which I where I need the correct value is showing as 0.000000. Seems trivial but not sure why this is happening. Is it also possible that grouping of other fields impacts this. Infact I have another column where the sum values pulls up fine. Have issue only with this particular column.

Thanks

JDong

@kelsey_kincaid @apathetichell

The data looks ok going into the summerize tool and is of the format Ex: 5,27 (comma is the delimiter) being used.Now the approach that @apathetichell suggested have used V_Wstring and second step uses the multirow forumla.

The input data is V_WString and hence the multirow works now

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703