Convert text into a number

Reply
White Belt

Re: Convert text into a number

This works.

Otherwose DOMO treats the 1st comma as the decimal point and rounds up rest of the number.

Example: 1,053, 233 will be treated as 1.00 when you perform mathematical operations.

                 REPLACE(`number_column`,',','') takes all the ',' off and makes the text 1053233, that is treated     like a number.

Visitor

Re: Convert text into a number

How can i use this function in domo dimenssion level.

Visitor

Re: Convert text into a number

I have a dimension that is actually number formate but domo showing Text(T). So i need to convert that text(T) into Number(123)..

 

Give me the replay how to do it.

White Belt

Re: Convert text into a number

This seems to be a problem with the data source. Just check if your source dataset is setting the right datatypes. If you cannot correct that, then change the column datatype in a workflow and power your card with the transformed dataset.

White Belt

Re: Convert text into a number

@DomoBeaver You can convert that column's datatype in a workflow to whole number Smiley Happy

Announcements
We want your feedback to improve the Dojo Community! If you are coming to the Dojo Award Ceremony next week Click here to learn more!