KB440851: Derived metrics with Round2 function return inconsistent result between MicroStrategy developer 10.x and Excel

SYMPTOM:
 
In Strategy developer 10.x, derived metrics with Round2 function return inconsistent result compared with Microsoft Excel.
 
 
REPRODUCING STEPS IN TUTORIAL:
 

• Create a report with attribute "Category" and metric "Profit". 
• Create a new derived metric with the formula of "Round2((Profit * 1.18), 2)". 
• Right mouse click on the New Metric, and select formatting>All Metric value, to ensure currency is selected with two decimal places.
• n the report and notice that the new derived metric for the Books shows as $671,748.46 as shown below:

• Calculate in Excel using formula of “=ROUND(569278.35*1.18,2)” the result shows $671,748.45 as shown below:

Note: The issue is reproducible on both Developer and Web.
 
 
CAUSE:
 
This is a known issue with Strategy 10.x.
 
 
 
ACTION:
 
 
This issue has been fixed in Strategy 10.4 Hotfix 6 and 10.11 GA. Upgrade to this version to take advantage of the fix.
 
 
 
Article Reference Number:   KB440851