Summarize Tool String to Number Issue

Hi Everyone,

I'm trying to use the summarize tool to group by product and sum the sales and units sold, but I received null values for sales (not sure if the units sold that came out are correct) when I run it.

Sales and units sold are string going into the summarize tool. I tried using Tonumber(), but had no luck.

Any help would be appreciated!

Tips and Tricks

Accepted answers

ponraj

First change the data type for Sales and Units to Numeric using select tool(place it before summarize tool). Thereafter if you run the workflow, you will get desired output.

All comments

JohnJPS

Hi @jboschee

The Imputation Tool would allow you to quickly replace all nulls with 0 for numeric fields.

Would that work for your needs?

jboschee

Hi @JohnJPS,

There should be values and not nulls. I thought I used a select tool and change them from string then that would work with the summarize tool, but something is off.

ponraj

First change the data type for Sales and Units to Numeric using select tool(place it before summarize tool). Thereafter if you run the workflow, you will get desired output.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703