String Conditional Statement

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

String Conditional Statement

Post by appleglaze28 »

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);
David Usherwood
Site Admin
Posts: 1458
Joined: Wed May 28, 2008 9:09 am

Re: String Conditional Statement

Post by David Usherwood »

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);
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Re: String Conditional Statement

Post by appleglaze28 »

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