% Sign in TM1 Rules?

Post Reply
youngjedi
Posts: 19
Joined: Thu Apr 26, 2012 10:52 pm
OLAP Product: TM1
Version: 9.5 - 10.1
Excel Version: Microsoft Excel 2010

% Sign in TM1 Rules?

Post by youngjedi »

What is the % sign used for in TM1 rules? I see this used in code I inherited. It doesn't look like it is for division as front and back slashes are used.

Thanks.
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: % Sign in TM1 Rules?

Post by David Usherwood »

It's in the docs - % is 'or' in logic tests.
Alan Kirk
Site Admin
Posts: 6667
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: % Sign in TM1 Rules?

Post by Alan Kirk »

youngjedi wrote:What is the % sign used for in TM1 rules? I see this used in code I inherited. It doesn't look like it is for division as front and back slashes are used.
David has given you the answer. Granted it's not always easy to search for individual operators in the documentation, which is why a link to the "Rules Syntax" chapter is one of the "Frequently Referenced Sections" found in the FAQ.
"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.
rdsjrcpa
Posts: 2
Joined: Mon Jun 30, 2008 6:50 pm

Re: % Sign in TM1 Rules?

Post by rdsjrcpa »

This is used as or statement.
Post Reply