KB37521: Percentile function is not working correctly if it is created with the insert function wizard in MicroStrategy Developer 10.x

SYMPTOM:
Percentile function is not working correctly if it is created with the insert function wizard in Strategy Desktop 10.x
 
STEPS TO REPRODUCE: 
Follow these steps to reproduce this issue with Strategy Tutorial project 9.2.1. 
 
 
 

1. Create a new Percentile metric using the insert function wizard and input "0.75" for the parameter K as shown below:
2. Click Finish and the metric has been successfully created as shown below.
   Note the percentile value K becomes 75.0 which is not correct.
     
3. Create a report with attribute Year and metric Revenue and the percentile metric. Run the report as shown below. Note the report result for the percentile metric is empty which is not correct. 

 
CAUSE:
This is a known issue in Strategy Developer.
 
ACTION:
Contact Strategy Technical Support for an update on this issue.
 
WORKAROUND:
Input the metric expression "Percentile(Revenue; 0.75)" manually instead of the input function wizard as shown below.
 
   

 
 
The report gives the correct result for the manually created percentile metric as shown below.