[SOLVED] Strange behaviour with formula

Post Reply
moritz
Posts: 15
Joined: Wed Sep 04, 2013 2:26 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

[SOLVED] Strange behaviour with formula

Post by moritz »

Hello guys,

something is wrong with my code:

Code: Select all

Sparte_PK='FALSCH';
pos=SCAN('HUS', Team);
if(pos>0);
Sparte_PK='HUS';
EndIf;
When i import my csv file via turbo integrator,
the element "FALSCH" is the only one what gets filled with data.

Although the example value displays "HUS":
Image
Last edited by moritz on Mon Oct 21, 2013 3:03 pm, edited 1 time in total.
Wim Gielis
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: Strange behaviour with formula

Post by Wim Gielis »

Can you please be more clear on the purpose?
Also, your screenshot is too small, we cannot see the variables names.
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
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Strange behaviour with formula

Post by Michel Zijlema »

Hi moritz,

In the screenshot I see that the transformation code is only defined on the MetaData tab, not on the Data tab. Where are you loading your data?

Michel
moritz
Posts: 15
Joined: Wed Sep 04, 2013 2:26 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: Excel 2010

Re: Strange behaviour with formula

Post by moritz »

Thank you for your quick support. :)

I just had to check the box "Daten".

Thank you very much and Greetings from Germany!
Wim Gielis
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: [SOLVED] Strange behaviour with formula

Post by Wim Gielis »

Keinen Dank !
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
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: [SOLVED] Strange behaviour with formula

Post by lotsaram »

Wim Gielis wrote:Keinen Dank !
I think you mean nichts zu danken. :)
Wim Gielis
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: [SOLVED] Strange behaviour with formula

Post by Wim Gielis »

Indeed, what was I thinking again ? :-)
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
Post Reply