Question about an operator...

Post Reply
Christian
Posts: 46
Joined: Wed Nov 18, 2009 8:43 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Question about an operator...

Post by Christian »

I apologize in advance if this is rudimentary. What does the @ sign do before the = sign in the following rule?

['6402 Transportation']=N:IF(DIMNM('Time',DIMIX('Time',!Time))@=
DB('Travel Plan',!Currency,!Budget Versions,!Year,!TripList,!Organization,'Month of Trip'),
DB('Travel Plan',!Currency,!Budget Versions,!Year,!TripList,!Organization,'6402 Transportation'),0);

I looked this up in the reference guide under arithmetic, logical and comparison operators and did not see it. I understand the rest of the statement.

Thanks a lot.
standtrue
Posts: 25
Joined: Sat Nov 07, 2009 5:37 am
OLAP Product: TM1, CX
Version: 9.5.2
Excel Version: 2007

Re: Question about an operator...

Post by standtrue »

You use the @ symbol if you are comparing strings e.g., vAlias @= 'Bob' or vAlias @<> 'Sally'.

You can just use = or <> if you are comparing numbers.
Christian
Posts: 46
Joined: Wed Nov 18, 2009 8:43 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2003

Re: Question about an operator...

Post by Christian »

Got it...I remember that now.

Thanks a lot Standtrue.
milena
Posts: 2
Joined: Sun Jan 03, 2010 10:46 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007 and 2003
Location: Sydney Australia

Re: Question about an operator...

Post by milena »

Thanks standtrue!

I'm also a noob and couldn't find this in the documentation :)

milena
Alan Kirk
Site Admin
Posts: 6647
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: Question about an operator...

Post by Alan Kirk »

milena wrote:Thanks standtrue!
I'm also a noob and couldn't find this in the documentation :)
Don't worry, you're not alone; there are some things in the documentation that even Indiana Jones couldn't find on a good day.

However if you want an overview of operators and syntax (which apply to TI to some extent as well) I suggest taking a look at the TM1 Rules Guide. You're on 9.4, and in that version it's on pages 1-69 and following.
"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.
Post Reply