OR in if statement in TI

tianya369

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.

xiaohei3721

Do a search for "tm1 logical operators"

hsszjw

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

王山振

Indeed. They can found in the reference guide.

yzbboy

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

xiphiasjoe

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 .

chenwu521

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.)