KB42447: How to apply conditional logic on a derived metric according to character attribute form in MicroStrategy Developer 9.4.x - 10.x

This document introduces how to apply conditional logic on a derived metric according to attribute form whose type is character.
For example, if attribute Region is 'Central' then derived metric value should be 'Profit + Cost'.
The following steps describes how to create such derived metric. Tutorial project is used here.
 

• Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'.
• Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '.
   
  

• Insert another derived metric 'M02' with expression 'IF(( = "Central"), (Profit - Cost), (Profit + Cost))'.
   
  

• Remove 'M01' from grid.
• Run report. 'M02' gives expect result as shown below.