# Insight select list values as numbers?

**URL:** <https://community.eazybi.com/t/insight-select-list-values-as-numbers/9879>\
**Category:** Questions & Answers\
**Tags:** insight, calculatedmembers\
**Created:** [June 24, 2022, 10:12am UTC](https://community.eazybi.com/t/insight-select-list-values-as-numbers/9879 "2022-06-24T10:12:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert](https://community.eazybi.com/letter_avatar_proxy/v4/letter/r/e95f7d/32.png) [@Robert](https://community.eazybi.com/u/Robert)\
**Post date:** [June 24, 2022, 10:12am UTC](https://community.eazybi.com/t/insight-select-list-values-as-numbers/9879/1 "2022-06-24T10:12:28Z")

</div>

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?

 ![image](https://community.eazybi.com/uploads/default/original/2X/1/158557117c4cb182bfe136aaa7a3cb34ad7104dc.png)

Thanks,  
Robert

---

<div class="post-metadata">

**Author:** ![nauris.malitis](https://community.eazybi.com/user_avatar/community.eazybi.com/nauris.malitis/32/6355_2.png) [@nauris.malitis](https://community.eazybi.com/u/nauris.malitis)\
**Post date:** [June 30, 2022, 3:46pm UTC](https://community.eazybi.com/t/insight-select-list-values-as-numbers/9879/2 "2022-06-30T15:46:51Z")

</div>

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:

```auto
[Object].CurrentHierarchyMember.GetNumber("Licenc Felhasználó szám")

```

1. You can also use the [Cast()](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference#MDXfunctionreference-Operators) function:

```auto
Cast([Object].CurrentHierarchyMember.Get("Licenc Felhasználó szám") as Numeric)

```

Best regards,  
Nauris / eazyBI support

---

<div class="post-metadata">

**Author:** ![Robert](https://community.eazybi.com/letter_avatar_proxy/v4/letter/r/e95f7d/32.png) [@Robert](https://community.eazybi.com/u/Robert)\
**Post date:** [July 5, 2022, 12:10pm UTC](https://community.eazybi.com/t/insight-select-list-values-as-numbers/9879/3 "2022-07-05T12:10:34Z")

</div>

Hello @nauris.malitis,

It works like a charm, thank you very much for your help!

Best regards,  
Robert