Managing number formatting between countries

Hi everyone,

I'm looking for advice on how to dynamically change number formatting in both the Anaplan model and UX based on the region or country. We have a development model that will be deployed across two countries, but they use different formats for decimals and thousands separators.

For example:

  • Canada uses a comma for thousands and a dot for decimals.
  • Many European countries use a dot for thousands and a comma for decimals.

I’ve searched through the forums but haven’t found a solution besides creating separate development models. However, we prefer to have just one model to serve multiple countries. Does anyone know of a way to handle these differences dynamically within a single model?

Any insights would be much appreciated!

Answers

  • Hi @rob_marshall, do we have this feature available in Anaplan?

  • Rnilsson
    edited September 25

    I would also like to hear if someone has any better insight.

    But what we have done to solve this issue in past projects have been to implement a solution to create the least amount of confusion (not using both comma and dot) and substituted the thousand separator with "space".

    headquarters in US
    thousand separator = space
    Decimal separator = dot

    headquarters in Europe:
    thousand separator = space
    Decimal separator = comma

  • @Error404 @Akhtar.shahbaz

    No, we don't have that at this time.

    @Rnilsson yes, that'll work, but I believe you are opening yourself up to a lot of issues down the road (sum's won't work, not to mention all of the text manipulation that you are having to do).

  • @rob_marshall
    Just to confirm, would the best approach here be to have two Development models that we keep in sync manually during development and for any future enhancements? This way, we can still use ALM to deploy to the respective production environments for each country.

  • @Error404

    No, I don't think two models are necessary. Are you thinking you need the two models because of the loading of data (files)? If so, you can click the Production Data checkbox for the file loads. If it is reviewing data, that is done by the settings on the browser.

  • @rob_marshall
    For both, Canada and Spain need to load their data in their local numbering format and also the user need to view and input data using their local format. I've tried to look for the setting in Chrome, so far I only found language settings. When I experimented with it, E.g put Spanish and remove every other language, it failed to display the expected format. It still display what's been setup within the Line Item format setting.