Small Numbers Return 0

Hi Everyone,

I was hoping someone could help solve why some of my data (values which are rather small) return 0 when I run my workflow and output the data.

The data looks fine when input, however once the workflow runs, all small numbers either return 0 or blank. I have tried using the select tool to change the data type to fixed decimal and so on.

It would be greatly appreciated if anyone has a solution to this problem. See reference material.

Thank you

Sample_Data1.xlsx

Sample_Workflow.yxmd

Workflow

Developer

Output

Data Investigation

Accepted answers

jyeung753

Hi,

I figured it out. I am using the Find Replace tool for the data mentioned in this workflow - I failed to realize I was appending the data with some rows not containing a CUSIP. Which was the factor reading in the data. After some adjustments I am able to return all lines of data without 0's.

I will mark this solved, thank you!

All comments

RSreeSurya

Hello,

I tried running your workflow, the numbers look fine and the total is also inline with the excel total. Could you please give an example , in which row number you are getting blanks or 0 along with screenshot, this helps to understand the issue.

jyeung753

Hi,

I will mark this solved, thank you!

Yoshiro_Fujimori

Hi @jyeung753 ,

I do not see zero or blank in the output data of your workflow.

But I see that the Select tool is configured to convert the number columns to Fixed Decimal (255.4), which is causing conversion errors.

Select tool configuration

Conversion errors

If you don't have a specific reason to use Fixed Decimal,

I would recommend changing the data type Double which will not cause conversion errors.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703