Custom number format in PAW View

Post Reply
ofintm1
Posts: 16
Joined: Tue Jun 21, 2016 4:26 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Custom number format in PAW View

Post by ofintm1 » Fri Mar 19, 2021 12:52 pm

Hi All,

I have a cube view opened in PAW (latest version) and need to display the numbers as thousands using the custom format functionality without changing the underlying TM1 database number format. In Excel I would use a number format such as #,##0,;(#,##0,); but ending the format string with a ',' doesn't work in PAW.

PAW now has a built-in thousands display format but includes 1 decimal place and a 'K' at the end of every number. See attached menu I am referring to. I want the same format with no decimal places and no 'K' suffix. I've had a look through the PAW and ICU documentation but struggling to find a solution.

Any help would be appreciated.

Thanks
Ollie
Attachments
Custom format.PNG
Custom format.PNG (33.57 KiB) Viewed 353 times

ofintm1
Posts: 16
Joined: Tue Jun 21, 2016 4:26 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Custom number format in PAW View

Post by ofintm1 » Sun Mar 21, 2021 1:09 pm

After playing with PAW 2.0.59 (correction - not the latest version) a bit more I realised even if I change the TM1 database format to thousands, the view and visualisations would not update. My main motivation for doing this was to get the chart labels on axes and data points looking sensible rather than displaying the full unformatted numbers.

I found a post on the IBM forum confirming the number formats in PAW visualisations are broken since v2.0.59. Hopefully fixed very soon as no mention of it in release notes for 2.0.6-62 and the visualisations are ruined by the inability to abbreviate any labels on the data or axes.

https://community.ibm.com/community/use ... gestviewer

Post Reply