cancel
Showing results for 
Search instead for 
Did you mean: 

Webi Char to Number

Former Member
0 Kudos

Hi experts,

I have a Webi report based on OLAP universe.

I'm facing few problems while sorting .Here is the problem

Eg:-Emp Number

5,8,10 ,11,22,82.

Ascending result:-10,11,11,5,8,82.Its behaving like this because Emp number is changed to Char in Universe level.So,the values of emp numbers are having as a string.

I tried to change the Emp Number type char to Number in Universe level-It's throwing driver incompatiable error when running webi report.

When I tried to use ToNumber in report level-It's giving #Error values in all columns.

Please guide me for the solution.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Tanb,

Try this =ToNumber(Replace([Object Term]);",";"")

Thanks,

Mayuri W.

Former Member
0 Kudos

Got the answer....

former_member539471
Participant
0 Kudos

Hello,

Please tell me how did you fix this?

Thanks a lot

Former Member
0 Kudos

ToNumber in report level is working fine now.

Here are the steps.

create a varibale on top of the char field and use Tonumber function.

Thanks

former_member200478
Active Participant
0 Kudos

Hi
I tried to create variable on top of char field.
Still i am facing that #ERROR thing.
Can u please help ??

Thanks & Regards
Tanb Gupta