EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB39382: "Invalid Expression" error message appears when attempting to revalidate an expression with both IF and IN functions in MicroStrategy Developer 9.x - 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


This technical note outlines an issue that occurs when using IF and IN functions in MicroStrategy Developer.

SYMPTOM:
In Strategy Developer 9.x - 10.x, the following error message appears when attempting to revalidate an expression with both IF and IN functions:


Error verifying form expression
Invalid Expression.

 
STEPS TO REPRODUCE:
Follow the steps below to reproduce the issue with Strategy Tutorial project:

  • In Strategy Developer, create an attribute using the following expression:    

    Sample Code/Error
    IF((BRAND_DESC In ( "A", "B")),  "C",  "D") 

     
  • Validate the expression and save it, as the image shown below:
ka02R000000kZKIQA2_0EM440000002DL0.jpeg
  • Edit the form again. The expression is changed to:  

    Sample Code/Error
    IF(( In "A" In "B"), "C", "D")

     
  • Validate the expression again, The validation fails and the following error occurs:
     
ka02R000000kZKIQA2_0EM440000002DL6.jpeg

CAUSE:
This is a known issue with Strategy Developer 9.x - 10.x.
 
 
ACTION:
Strategy is investigating the issue and will continue posting updates as soon as they become available.
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 20, 2017

Last Updated:

June 20, 2017