PA 2.09 Code function negative number

Post Reply
_BM_
Posts: 4
Joined: Wed May 06, 2020 2:56 pm
OLAP Product: TM1/Planning Analytics
Version: 10.2.2 / 2.07
Excel Version: 2013

PA 2.09 Code function negative number

Post by _BM_ »

Hello,

I'm currently testing PA 2.09. I've now noticed that PA seems to return a different value for the CODE function.
However, it only seems to affect umlauts.
The server parameters are the same for version 10.2.

Does anyone have any idea why this might be?
Attachments
Screen.PNG
Screen.PNG (10.63 KiB) Viewed 119 times
User avatar
gtonkin
MVP
Posts: 1056
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.9.10; PAW 2.0.71
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: PA 2.09 Code function negative number

Post by gtonkin »

Have you tried using CodeW?

Edit: Looks like it should be 220 so CodeW not needed. Will test tomorrow and post results. Also -36 is suspiciously like 220-256…
lotsaram
MVP
Posts: 3566
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: PA 2.09 Code function negative number

Post by lotsaram »

Just replicated this and yes CodeW produces the correct result. But what the hell is CodeW? It's undocumented. Why does this exist as opposed to the Code function actually producing the correct result?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
gtonkin
MVP
Posts: 1056
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.9.10; PAW 2.0.71
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: PA 2.09 Code function negative number

Post by gtonkin »

CodeW and CharW are both undocumented but for use with characters above #FF or non-8-bit.

Edit: Looks like IBM have recently added a page for CodeW and CharW
_BM_
Posts: 4
Joined: Wed May 06, 2020 2:56 pm
OLAP Product: TM1/Planning Analytics
Version: 10.2.2 / 2.07
Excel Version: 2013

Re: PA 2.09 Code function negative number

Post by _BM_ »

With CODEW it seems to fit.
It's still strange that there are differences here.

Thanks very much!
User avatar
gtonkin
MVP
Posts: 1056
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.9.10; PAW 2.0.71
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

Re: PA 2.09 Code function negative number

Post by gtonkin »

I would recommend that you log a case to get IBM to review and address rather than change your code.
Post Reply