KB5892: How to create a metric that calculates the greatest metric value of three metrics in MicroStrategy Developer 9.x

The metric to calculate the greatest value out of the three metrics can be defined by performing the following steps:

1. Create a new metric.
2. Type the following custom expression in the metric editor:
   ApplySimple("CASE WHEN #0 > #1 AND #0 >#2 THEN #0 WHEN #2>#1 AND #2>#0 THEN #2 ELSE #1 END", , , )
    
   Here Metric 1, Metric 2 and Metric 3 are the names of different metrics that are being compared. The metric expression is illustrated below.