Data type won't change from Test to Number?

[trevorG1]

Hi, 

I have a report see below, where in one of the columns "D" I am unable to change Data Type to Whole Number, alonng with Format to Whole Number and Summarization to Sum. 

The one difference I noticed is the numbers are displayed on the left hand side of the column unl;ike the rest whicj are to the right.

Any ideas?

[trevorG1]

ct that worked, thanks Joe

[Idrissshatila]

Hello @trevorG1 ,

yes as @JoeBarry  mentioned, and also check if all the records in the column are numbers.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[JoeBarry · Accepted solution]

Hi @trevorG1 

It's still formated as Text or as Any.

Go back to Query Editor and convert to Number there and load back in

Thanks

Joe

If this post helps, then please consider Accept it as the solution