PROPER function not working in xcelsius

[Former Member]

Hi,

I am using PROPER function in Xcelsius to convert upper case text to Proper case.But it is giving an error of unsupported function.

Can anyone please tell me any replaceable function in xcelsius to convert text to Proper case.

Thanks,

Rajesh

[former_member207052]

Proper is not supported in Dashboards. you have to use the combination of Upper and lower functions to achieve the same. So, your formula would be something like:

UPPER(LEFT(A1,1))&LOWER(MID(A1,2,LEN(A1)))

Optionally, you can consider doing this at your data source or universe level if applicable.

[Former Member]

Hi Narashimman,

Thanks for your reply.

But the text which i want to convert is as below

ASIA AREA TOTAL to Asia Area Total.

Can you please provide formula to above conversion if possible.

Thanks,

Rajesh

[vijaymuniraj]

Hi Rajesh,

What is your data source? If it is BI, change it on back end.

[former_member207052]

As I mentioned in my previous post, doing at universe or data source would be easier. It is not impossible within dashboards, but just that it is complex and not my personal favorite.

If you have no other way, use the below formula to achieve the same.

B1=FIND(" ",A2,1)

C1=FIND(" ",A2,B2+1)

D1=UPPER(LEFT(LEFT(A2,B2-1),1))&LOWER(MID(LEFT(A2,B2-1),2,10)) & " " &UPPER(LEFT(MID(A2,B2-1,C2-B2),1))&LOWER(MID(MID(A2,B2+1,C2-B2),2,10)) & UPPER(LEFT(RIGHT(A2,LEN(A2)-C2),1))&LOWER(RIGHT(A2,LEN(A2)-C2-1))

[vijaymuniraj]

hi,

are you using proper function in Excel? Can you provide some screen shot on error u get?

Thanks

Vijai muniraj

[Former Member]