Hi everyone,
I am doing some test projects with Performance Modeler, and I would like to know if someone know where I can find a syntax guide for the expressions that you find inside the "Maps" tab for the "Calculated Column" when you edit a Link.
I was able to concatenate strings, but it looks is not working for integers and arithmetic operations.
Thank you in advance!
Performance Modeler - Expression Syntax
-
- Posts: 1
- Joined: Fri Oct 20, 2017 10:47 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
-
- MVP
- Posts: 3240
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Performance Modeler - Expression Syntax
Concatenation with the pipe character requires 2 strings. Therefore non numeric components need to be converted to strings and then concatenated. The function Str is a possibility.emanuelarico wrote: ↑Fri Oct 20, 2017 1:07 pm I was able to concatenate strings, but it looks is not working for integers and arithmetic operations.
Thank you in advance!
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly