Scan on an empty string

Post Reply
Wim Gielis
Posts: 2741
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.8
Excel Version: Microsoft 365
Location: Brussels, Belgium

Scan on an empty string

Post by Wim Gielis » Thu Apr 29, 2021 6:28 pm


I had to investigate a tricky mapping process with TM1 data going to Hyperion Financial Management (HFM).

Actually, it turns out that using the Scan function with an empty string, to be looked up in a non-empty string, gives a result of 1. Not 0.

Be aware of this :-)
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 117 TM1 articles and a lot of custom code
Newest blog article: Avoid circular references

20 Ton Squirrel
Posts: 23
Joined: Tue Jul 14, 2020 9:53 pm
OLAP Product: TM1
Version: 11.7.00002.1
Excel Version: Office 365

Re: Scan on an empty string

Post by 20 Ton Squirrel » Mon May 03, 2021 7:16 pm

*peers into a box looking for an empty*

My god, it is FULL of nothings! ×___×

Thanks for posting on this, one of the projects I'm working on is using SCAN in a few spots. I'll keep this in mind.
TM1 Version: 11.8.00200.24

User avatar
Posts: 535
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: Scan on an empty string

Post by PavoGa » Tue May 04, 2021 1:12 pm

"Nothing from nothing leaves nothing"

-Billy Preston

Who knew Billy was a TM1 expert back in 1974. :lol:
Cleveland, TN

Post Reply