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.
Question about an operator...
-
- 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...
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.
You can just use = or <> if you are comparing numbers.
-
- Posts: 46
- Joined: Wed Nov 18, 2009 8:43 pm
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
Re: Question about an operator...
Got it...I remember that now.
Thanks a lot Standtrue.
Thanks a lot Standtrue.
-
- 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...
Thanks standtrue!
I'm also a noob and couldn't find this in the documentation
milena
I'm also a noob and couldn't find this in the documentation

milena
-
- 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...
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.milena wrote:Thanks standtrue!
I'm also a noob and couldn't find this in the documentation![]()
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.