Insight select list values as numbers?

Hello Guys,

I imported an Insight object with a select list attribute where the values are numbers. When I use the “order by” function in the table, then it seems that the values are treated as texts instead of numbers. I tried to change the formatting of the measure to Decimal, but it didn’t help.

[Measures].[Object Licenc Felhasználó szám] = [Object].CurrentHierarchyMember.get(‘Licenc Felhasználó szám’)

Could you help me to solve the question?

Thanks,
Robert

Hi @Robert

You are correct. The values are sorted alphabetically as text values.
There are a couple of options for how you can convert text values to a numeric format:

  1. You can use the “.GetNumber” function on your Object member as follows:
[Object].CurrentHierarchyMember.GetNumber("Licenc Felhasználó szám")
  1. You also use the Cast() function:
Cast([Object].CurrentHierarchyMember.Get("Licenc Felhasználó szám") as Numeric)

Best regards,
Nauris / eazyBI support