ELSLEN Function throws error in TI

Post Reply
dharav
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

Post by dharav »

ELSLEN.JPG
ELSLEN.JPG (75.13 KiB) Viewed 4049 times
Hello All

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
Duncan P
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

Post by Duncan P »

IBM Doc for ELSLEN wrote: ELSLEN
This is a CXL worksheet function, valid only in worksheets.
Alan Kirk
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

Post by Alan Kirk »

"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.
BariAbdul
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

Post by BariAbdul »

I think Long is the function you should be looking at. :)
"You Never Fail Until You Stop Trying......"
dharav
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

Post by dharav »

thank you all.
Post Reply