KB249837: "Syntax error" message is shown when creating a derived metric with an IF condition in MicroStrategy Web 9.4.1 and 10.x

SYMPTOM:
If a derived metric condition with an IF statement is added when the user's number format is different than English, the statement will not be valid in Strategy Web 9.4.1 and 10.x
In Strategy Web 10.

Syntax error!
The metric definition has an error. Please correct before proceeding.
Validation failed with syntax error!

An error occurred processing this Editor request. Please contact your Administrator.

• Create a report with Cost and Region.
• Create a derived metric with the following definition:
  

  
  Max(IF(([Cost] = 1),1,0)){} 

  
  
• Click "OK" and the derived metric is created correctly as expected when using English language.
• Go to preferences and change the language for "Number and Date Format" to French, as shown below:
  

• Logout and log back into Strategy Web.
• Attempt to create the same derived metric from step 2.
• Notice that the error message is received.

 
CAUSE:
This is an identified defect in Strategy Web 9.4.1 and 10.x
 
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release.
 
The Strategy Internal Reference Number for the issue discussed in this technical note is 1016337.