Trouble converting string to numbers?

Question

Hi all,

I'm trying to create a column that buckets the durations into a "31+" and "Less than 30" category. I tried converting the "duration" column to a number using the ToNumber function, but when I use the subsequent IF statement the data comes out riddled with errors below (e.g. row 1 is 4.28, clearly should not be in the 31+ bucket)

I think the problem may be how I converted the string? Or is it something else? Attached my sample workflow for reference. Any help is greatly appreciated!

sample workflow.yxmd

Thableaus · Accepted Answer

Hi @drewh

Change these two things - First, in your ToNumber formula, you must specify the field as a Double Type.

Then, you can also take off the single quotes around 30, so it is considered as numeric type.

Cheers,