Skip to main content
The way to achieve your own success is the willingness to help somebody else. Go for it!
Showing results for 
Search instead for 
Did you mean: 
Partner - Contributor III
Partner - Contributor III

Dimension values are coming as " ? " (question mark) in sheets instead of number format

Hello experts,

Kindly try to answer my question in the below link: 

Labels (1)
1 Reply
Champion III
Champion III

This is because the same column has conflicting datatypes

for example first few rows loaded as NUMBERS and then subsequent data was loaded as TEXT


If you are confident all values are NUMBERS try to force the format as 

Num(FieldName) as FieldName

Try to verify there are no garbage characters or force numbers using keepchar()

keepchar(FieldName,'0123456789') as FieldName

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.