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
Comma separator shows in Perspective but point in Navigator
-
- 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
What is the language and number format of the computer that has Perspectives running on it?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 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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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 ).Alan Kirk wrote: ↑Fri Mar 05, 2021 10:09 amWhat is the language and number format of the computer that has Perspectives running on it?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 is running the TM1 Web service?
I would not be surprised if the two are not the same.
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