Forum Discussion

trevorG1's avatar
trevorG1
Regular Visitor
3 years ago
Solved

Data type won't change from Test to Number?

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?

 

 

 

 

Need Help
  • JoeBarry's avatar
    JoeBarry
    3 years ago

    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 

3 Replies

  • JoeBarry's avatar
    JoeBarry
    Icon for Solution Sage rankSolution Sage
    3 years ago

    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