amount field type importing as Text

sgraham

ANyone know why when i select a data source with an Amount Column, Domo is recognizing it as Text rather than Amounts?  How can i correc this?

Godiepi

where does the data originates from before making it into Domo ?

from a sql view uploading through wrokbench ?

from an excel spreadsheet store in your machine or in box or other uploading it into Domo using a connector ? etc

sgraham

an excel file on a server

Godiepi

if you can , go into the excel and make sure that all values in the columns showing amounts has nothing other than numeric values... what happends is that usually the excel is updated by a person and if someone enters a text value by error in one cell , it makes the whole column a text column. 

it could be a comma , a space or anyother value what is turning the whole column into text.

make the correction, save and re-run the load into Domo.

sgraham

I don't see anything other than values in the column

Godiepi

Can you run a formula on your excel for that column ... =ISNUMBER(yourcolumncell)   and drag it down til the last record, see if any returns false

sgraham

I did that and there are no False

Godiepi

Gosh ? i'm running out of ideas.

 

is the column generated from a formula in the excel ?

 

last thing to do is to create a data flow in Domo , magic etl , bring the input dataset and from the edit column menu use the set column type option to force the column to display as number instead of text in Domo.

sgraham

No, just contains numbers

kshah008

@sgraham, were you able to resolve your issue?

Unknown

You can put it through a dataflow and cast to number.