amount field type importing as Text
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?
Comments
-
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
0 -
an excel file on a server
0 -
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.
0 -
I don't see anything other than values in the column
0 -
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
0 -
I did that and there are no False
0 -
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.
0 -
No, just contains numbers
0 -
You can put it through a dataflow and cast to number.
1
