Ssas - How To Configure Format Number For Calculated Measures?

I created a calculated measure in order to allow user to display the operating margin about sales. ROUND([Measures].[Total] - [Measures].[Total Cost],2) It works well, however I g

Solution 1:

In your SSAS project you can use "Format string" field to specify the format:

In the code it looks this way:

CREATE MEMBER CURRENTCUBE.[Measures].[ASP]
 AS [Measures].[Amount]/[Measures].[Units], 
FORMAT_STRING = "$#,##0.00;($#,##0.00)";     

Use either manual string to create exact look or if all your environments are properly set up as French locale, there is a standard "Currency" format string which also might work in your favor.