Page 1 of 1

tm1 rules problem

Posted: Thu Nov 07, 2024 5:27 am
by sairajsoma
skipcheck;

'base annual pay' and 'worker type' are element of measure dimension. 'worker type' is string element having 'a' value at one intersection. while saving rule i am getting syntax error. could anyone find the error.

['base annual pay']=N:if(['worker type']@='a',0,1);

Re: tm1 rules problem

Posted: Thu Nov 07, 2024 6:39 am
by glaurens
Use the DB() format when referring to a String measure

Re: tm1 rules problem

Posted: Fri Nov 08, 2024 5:36 pm
by ardi
sairajsoma wrote: Thu Nov 07, 2024 5:27 am skipcheck;

'base annual pay' and 'worker type' are element of measure dimension. 'worker type' is string element having 'a' value at one intersection. while saving rule i am getting syntax error. could anyone find the error.

['base annual pay']=N:if(['worker type']@='a',0,1);
For String Measures, you need to use DB function.

Re: tm1 rules problem

Posted: Fri Jan 03, 2025 7:03 am
by sairajsoma
Okay, Thanks