TM1 Forum

Posted: **Sun Aug 08, 2010 3:58 am**

Hi guys I was hoping if you can help me out with my problem...

I have this conditional statement that use string value from a picklist but I'm having an "incorrect logical comparision"

['>>>End Specification Discount'] = S: IF (DB('CD_product_announcements', !base_customers_and_distributors, !base_products, 'New Product/ Phase Out')='Phase Out','',CONTINUE);

Code: Select all

Posted: **Sun Aug 08, 2010 8:33 am**

See the manual - string comparison tests need an @ before the operator.

Code: Select all

['>>>End Specification Discount'] = S: 
  IF (DB('CD_product_announcements', !base_customers_and_distributors, !base_products, 'New Product/ Phase Out')@='Phase Out',
  '',
#else
  CONTINUE);

Posted: **Sun Aug 08, 2010 9:01 am**

Thanks David...I keep forgetting that "@"

TM1 Forum

String Conditional Statement

String Conditional Statement

Re: String Conditional Statement

Re: String Conditional Statement