Comma separator shows in Perspective but point in Navigator

Post Reply
Seboby
Posts: 3
Joined: Fri Jan 22, 2021 12:27 am
OLAP Product: tm1
Version: 10.2
Excel Version: 2010

Comma separator shows in Perspective but point in Navigator

Post by Seboby »

Hello TM1ers,

I am facing an issue in TM1 while trying to add numbers comma separator in Active form. It seem working in Persepective but in TM1 Web the comma becomes a Point separator.

I tryed switching to point in perspective in hope that it will be come a comma but it didnt work.


I am using the custom format : #,##0 ;;0
it shows number : 100 123 000 ==> 100,123 in perspective and 100.123 in Web.

Did you ever faced a problem Like tsi before ? Is it normal Why does it happen ? ?Is there any fix for this ?

Thanks
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Comma separator shows in Perspective but point in Navigator

Post by Alan Kirk »

Seboby wrote: Fri Mar 05, 2021 9:56 am I am facing an issue in TM1 while trying to add numbers comma separator in Active form. It seem working in Persepective but in TM1 Web the comma becomes a Point separator.

I tryed switching to point in perspective in hope that it will be come a comma but it didnt work.


I am using the custom format : #,##0 ;;0
it shows number : 100 123 000 ==> 100,123 in perspective and 100.123 in Web.

Did you ever faced a problem Like tsi before ? Is it normal Why does it happen ? ?Is there any fix for this ?
What is the language and number format of the computer that has Perspectives running on it?
What is the language and number format of the computer that is running the TM1 Web service?

I would not be surprised if the two are not the same.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Seboby
Posts: 3
Joined: Fri Jan 22, 2021 12:27 am
OLAP Product: tm1
Version: 10.2
Excel Version: 2010

Re: Comma separator shows in Perspective but point in Navigator

Post by Seboby »

Alan Kirk wrote: Fri Mar 05, 2021 10:09 am
Seboby wrote: Fri Mar 05, 2021 9:56 am I am facing an issue in TM1 while trying to add numbers comma separator in Active form. It seem working in Persepective but in TM1 Web the comma becomes a Point separator.

I tryed switching to point in perspective in hope that it will be come a comma but it didnt work.


I am using the custom format : #,##0 ;;0
it shows number : 100 123 000 ==> 100,123 in perspective and 100.123 in Web.

Did you ever faced a problem Like tsi before ? Is it normal Why does it happen ? ?Is there any fix for this ?
What is the language and number format of the computer that has Perspectives running on it?
What is the language and number format of the computer that is running the TM1 Web service?

I would not be surprised if the two are not the same.
Thank you for pointing this out. Indeed they are not the same. To recover from this I only made Excel perspective not use sytem separators ( option -> advanced -> uncheck system separator ).

I was able to show comma separator in Chrome navigators but failed in Internet Explorer. I dont know if i there is a better solution that will make the Comma Seperator show no matter the navigator type .

Thanks
Post Reply