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: 3120
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- 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
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
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