Skip to main content
Aug 10, 2021 4:43 PM UTC

Can you get Cube View cell number formatting to display/accept European number formatting?

 

Answer

  • First, you must make sure the Users have the appropriate Culture setting assigned to them in Security:
OSAdmin_0-1628090175908.png

 

  • Assuming no overriding formats are on the Cube View, values will appear as follows for US vs. French culture settings:

OSAdmin_1-1628090227461.pngOSAdmin_2-1628090240433.png
  • You can then apply Standard Number formatting options (e.g., N0, N1, etc.) to control decimal display
  • You cannot apply custom formatting strings, as they would override the above, such as: OSAdmin_3-1628090279457.png 

     

 

Source: Office Hours 2020-08-27 Partner Enablement