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
Looking for the latest Community solutions? Please visit our accepted solutions board here!