Page 1 of 1

Question about an operator...

Posted: Wed Nov 25, 2009 2:39 pm
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.

Re: Question about an operator...

Posted: Wed Nov 25, 2009 2:45 pm
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.

Re: Question about an operator...

Posted: Wed Nov 25, 2009 2:58 pm
by Christian
Got it...I remember that now.

Thanks a lot Standtrue.

Re: Question about an operator...

Posted: Mon Jan 04, 2010 5:45 am
by milena
Thanks standtrue!

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

milena

Re: Question about an operator...

Posted: Mon Jan 04, 2010 6:01 am
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.