[SalesForce] Format decimal number with thousand separator with a dot (.)

I would like to format a visualforce variable '{!TotalE}' with a thousand separator as . notation for example

123386258.00 becomes 123.386.258

I have tried examples of
outputtext 'value="{0, number, #,###,###,##0}"' this returns 123,386,258 what i would like to achieve is 123.386.258 like a swedish format

Best Answer

Try using apex:outputField, it would do the formatting for you based on your locale.

Unfortunately its not possible with apex:outputText and apex:param. Here is a similar idea.

There was a comment in the idea which could be helpful but would need bit of modification as per requirement:

Option 1: Standard

<apex:outputText value="{0, number, ###,##0.00}">
    <apex:param value="{!Opportunity.Amount}"/>
</apex:outputText> </span>

result : 100,000.00

Option 2: Custom formulas

<span>
    {!IF(Opportunity.Amount < 0, 
        "-", 
        "") & 
        IF(ABS(Opportunity.Amount) >= 1000000, 
            TEXT(FLOOR(ABS(Opportunity.Amount) / 1000000)) & ".", 
            "") & 
        IF(ABS(Opportunity.Amount) >= 1000, 
            RIGHT(TEXT(FLOOR(ABS(Opportunity.Amount) / 1000)), 3) & ".", 
            "") & 
        RIGHT(TEXT(FLOOR(ABS(Opportunity.Amount))), 3) & "," & 
        IF(MOD(ABS(Opportunity.Amount) , 1) * 100 < 10, 
            "0" & TEXT(ROUND(MOD(ABS(Opportunity.Amount), 1), 2) * 100), 
            TEXT(MIN(ROUND(MOD(ABS(Opportunity.Amount) , 1), 2) * 100, 99))
        )}
</span>

Result: 100.000,00

Related Solutions

[SalesForce] How to use locale settings for decimal separator

if you use the following functions in SOQL queries, it will support localized result

SELECT statements can include the toLabel() and convertCurrency() functions in support of localized fields.

toLabel():

Use toLabel() on regular, multi-select, division, or currency code picklist fields (any field that has picklist values returned by the relevant describe call), data category group and data category unique name fields or RecordType names. Any organization can use toLabel(). It is particularly useful for organizations that have the Translation Workbench enabled. For example:

SELECT Company, toLabel(Recordtype.Name) FROM Lead

This query returns lead records with the record type name translated into the language for the user who issued the query.

convertCurrency():

If an organization is multicurrency enabled, you can use convertCurrency() in the SELECT clause to convert currency fields to the user's currency. Use this syntax for the SELECT clause: convertCurrency(field) For example:

SELECT Id, convertCurrency(AnnualRevenue) FROM Account

If an organization has enabled advanced currency management, dated exchange rates will be used when converting currency fields on opportunities, opportunity line items, and opportunity history. For more information, check the SOQL documentation in salesforce

[SalesForce] How to display ‘%’ with only one decimal

The % character is supported as part of the outputText format.

You can use syntax like this to achieve the formatting you want

<apex:outputText value="{0, number, ###.0%}">
    <apex:param value=".....your value here...."/>
</apex:outputText>

Best Answer

Related Solutions

[SalesForce] How to use locale settings for decimal separator

[SalesForce] How to display ‘%’ with only one decimal

Related Topic