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?
PA 2.09 Code function negative number
-
- 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
- Attachments
-
- Screen.PNG (10.63 KiB) Viewed 1031 times
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: PA 2.09 Code function negative number
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…
Edit: Looks like it should be 220 so CodeW not needed. Will test tomorrow and post results. Also -36 is suspiciously like 220-256…
-
- MVP
- Posts: 3654
- 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
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.
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: PA 2.09 Code function negative number
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
Edit: Looks like IBM have recently added a page for CodeW and CharW
-
- 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
With CODEW it seems to fit.
It's still strange that there are differences here.
Thanks very much!
It's still strange that there are differences here.
Thanks very much!
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: PA 2.09 Code function negative number
I would recommend that you log a case to get IBM to review and address rather than change your code.