ELSLEN Function throws error in TI
-
- Regular Participant
- Posts: 193
- Joined: Wed Apr 02, 2014 6:43 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
ELSLEN Function throws error in TI
I want to find the length of the string so that i utilized ELSLEN function in my TI. Unfortunately, it is not working. I have attached the copy of error message along with my TI code for your reference. I utilized ELPAR and it works.
Could you throw some light on this issue? Is there any other way to find out the length of the string?
Thank You
Dharav
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: ELSLEN Function throws error in TI
IBM Doc for ELSLEN wrote: ELSLEN
This is a CXL worksheet function, valid only in worksheets.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: ELSLEN Function throws error in TI
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: ELSLEN Function throws error in TI
I think Long is the function you should be looking at. 

"You Never Fail Until You Stop Trying......"
-
- Regular Participant
- Posts: 193
- Joined: Wed Apr 02, 2014 6:43 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2010
Re: ELSLEN Function throws error in TI
thank you all.