This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!