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 n...
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 

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