KB300312: When trying to use the ‘Use 1000 Separator (,)’ for fixed format in a VI dashboard for a metric; the setting will not take effect in MicroStrategy Web 10.x.

SUMMARY:
This issue has been classified as a defect by Strategy.  A workaround is available in the current document. A solution/code fix for this issue is not available in current releases and has not been scoped for a future Strategy release.
SYMPTOM:
When trying to use the ‘Use 1000 Separator (,)’ in conjunction with the third button for fixed format in a VI dashboard for a metric; the setting will not take effect.
STEPS TO REPRODUCE:

1. Create a VI dashboard using the Category Sales Report.
2. Add the Category attribute and the Revenue metric in a grid visualization.

1. Right click the Revenue metric and go to Number Format, the Automatic option will be chosen by default; change it to Fixed by selecting the 3rd button.

         - Decrease the number of decimals so no decimals are shown.
         - Without closing this, select the "Use 1000 Separator" option.
         - Click Ok.
 

1. Notice the separator is not added:

1. Right click the Revenue metric and go to Number Format and notice the option is not checked:

 
CAUSE:
This is a known issue in Strategy Web 10.x.
ACTION:
This issue has been fixed in Strategy Web 10.10, upgrade to this version to take advantage of the fix.
WORKAROUND:
The issue does not occur if the dropdown for the Number format is used and then the checkbox for ‘Use 1000 Separator (,)’ is used: