Search found 3 matches

by semaxan
Thu Oct 29, 2020 1:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Number Format to Make Zeros display -?
Replies: 4
Views: 2661

Re: Custom Number Format to Make Zeros display -?

Actually, instead of using a short hyphen - I preferred the longer en-dash (ALT+0150). You could also use the even longer em-dash ALT+0151. But the middle one is the one I use.
by semaxan
Thu Oct 29, 2020 1:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Number Format to Make Zeros display -?
Replies: 4
Views: 2661

Re: Custom Number Format to Make Zeros display -?

I was helped to get the following format in Architect without showing any decimals but with thousand separation using spaces.
Image
by semaxan
Fri Oct 23, 2020 8:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Snapshot of TM1 Web report to Excel only creates values for first sheet
Replies: 0
Views: 3425

Snapshot of TM1 Web report to Excel only creates values for first sheet

Hi, I have several TM1 Web websheet reports which contain several sheets. When exporting as Snapshot to Excel, it generates an excel file converting only the first page (which holds my parameters in drop boxes) to static values but not my DBRW or excel formulas in the other sheets. Any ideas why tha...