TM1 Forum

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

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.

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