TM1 Forum

Hi

I AM TRYING TO WRITE A RULE MIMICKING AN EXCEL BY COMPARING 2 VALUES IN A CUBE . NOT SURE IF I AM DOING CORRECTLY.

IN EXCEL THE LOGIC IS IF HIGHESTREMOVAL IS 0 THEN NEW ALLOCATION

['FINALALLOCATION' ] = N:IF(['HIGHESTREMOVAL' ] @= 0, ['NEWALLOCATION' ] ,STET);

APPRECIATE YOUR HELP.

ALAHARI wrote:Hi

I AM TRYING TO WRITE A RULE MIMICKING AN EXCEL BY COMPARING 2 VALUES IN A CUBE . NOT SURE IF I AM DOING CORRECTLY.

IN EXCEL THE LOGIC IS IF HIGHESTREMOVAL IS 0 THEN NEW ALLOCATION

['FINALALLOCATION' ] = N:IF(['HIGHESTREMOVAL' ] @= 0, ['NEWALLOCATION' ] ,STET);

APPRECIATE YOUR HELP.

"@=" is for string comparisons. For numeric just use "=".

Thanks!!!!Tom

I am trying to replicate the below string case statement . can you please correct me

excel-=IF(AND(LANDINGS="NO",'CURRENTONHAND'>0),"Excess Stock",
IF(AND(LANDINGS="NO",CURRENTONHAND>0),"Excess Allocation",

['REVIEWCODE' ] = N:IF (!LANDINGS @= 'NO' & ['CURRENTONHAND' ] > 0, 'EXCESS STOCK',CONTINUE);
['REVIEWCODE' ] = N:IF (!LANDINGS @= 'NO' & ['CURRENTALLOCATION' ] > 0, 'EXCESS STOCK');

Perhaps:

Just to add to Wim's reply you need to use =S: notation to populate a string (text) measure; for this to work you need to make sure that ReviewCode exists in the dimension that is last in order in the cube and is given a string type.

You can also make the code slightly shorter; the !landings notation can go on the left hand side of your rule and you can remove the need for 2 separate statememts:

Thanks you guys!!!