OR in if statement in TI

jcblough · Post by **jcblough** » Mon Apr 16, 2012 1:24 pm

does this exist, I have the following statement:

['Forecast', '06XW'] =N: IF(('ESP Sales' @= !SSP_m), Continue, 0);

It is zeroing out values for an entire level of a cube sans the measure 'ESP Sales' I want it to leave ESP Sales and another value, is there a proper 'or' structure? "OR", '|', and '||' do not work.

lotsaram · Post by **lotsaram** » Mon Apr 16, 2012 1:43 pm

Do a search for "tm1 logical operators"

Michel Zijlema · Post by **Michel Zijlema** » Mon Apr 16, 2012 1:44 pm

jcblough wrote:does this exist, I have the following statement:

['Forecast', '06XW'] =N: IF(('ESP Sales' @= !SSP_m), Continue, 0);

It is zeroing out values for an entire level of a cube sans the measure 'ESP Sales' I want it to leave ESP Sales and another value, is there a proper 'or' structure? "OR", '|', and '||' do not work.

The OR operator is represented by "%".

But in your case you could change the rule to:

['Forecast', '06XW', {'ESP Sales', 'another value'}] =N: 0;

Michel

jim wood · Post by **jim wood** » Mon Apr 16, 2012 1:44 pm

Indeed. They can found in the reference guide.

jcblough · Post by **jcblough** » Mon Apr 16, 2012 3:25 pm

Thanks, I've seen alot of things, but "%" for OR is a new one.

Alan Kirk · Post by **Alan Kirk** » Mon Apr 16, 2012 7:39 pm

jim wood wrote:Indeed. They can found in the reference guide.

And a link to that section of the guide was included under the "Frequently Referenced Sections" heading of the FAQ.

jim wood · Post by **jim wood** » Mon Apr 16, 2012 8:10 pm

A link can also be found under the help menu with Architect / Server Explorer. Spoilt for choice really!!!

(Not to forget the PDF version in doc library.)

TM1 Forum

OR in if statement in TI

OR in if statement in TI

Re: OR in if statement in TI

Re: OR in if statement in TI

Re: OR in if statement in TI

Re: OR in if statement in TI

Re: OR in if statement in TI

Re: OR in if statement in TI