How can I order a Column where the type is text, but all the values stored are numeric,
I want to order it descending but considering the Column a Numeric field without changing the column type
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
There is no way to do this using CAML.
So This was my solution :
I created a Calculated column based on the original column with output type as numeric
There was a problem though. the calculated column at the beginning was returning the result as text too.
To fix this issue I had to do the following :
1.- ad a +"0" to the formula
I don't know how or why this worked, but doing this it transformed all the items into numeric.