[SalesForce] Displaying a % number as 2 decimals places and with a % sign at the end

I want to display a percentage number in my visual force page and I want it to have 2 decimal places and a % sign following the number (eg. 2.50%).

I have a custom field of type Percent and I called it Rate__c in my custom object app__c.

I current have this line of code in my VF page please help me confirm if it is doing the right thing as I have asked?

<apex:outputText value="{0, number, ##.##}%"><apex:param value="{!app.Rate__c}"/></apex:outputText>

I have looked up and some other sources suggest it to be written like this:

<apexutputText value="{0, number, 000,000.00}">

I am also not quite understand what is the different between using the "#" vs using the 0 when formatting the number.

Thanks

Best Answer

In this case, it'd be easier to just use <apex:outputField>. It automatically applies formatting based on the field metadata (i.e. Type = percentage and decimals = 2).

This behavior is documented. From the documentation on <apex:outputField>(emphasis mine)

A read-only display of a label and value for a field on a Salesforce object. An <apex:outputField> component respects the attributes of the associated field, including how it should be displayed to the user. For example, if the specified <apex:outputField> component is a currency field, the appropriate currency symbol is displayed. Likewise, if the <apex:outputField> component is a lookup field or URL, the value of the field is displayed as a link.

Related Solutions

[SalesForce] Controlling the data type of a custom field

The length and decimal places are only enforced when editing data via the standard web UI. Apex and API methods can actually save records with decimal places. This is true for standard and custom fields. To restrict the values to an integer, you'd have to put a validation rule in place or add a trigger to the object to do the validation.

EDIT: In the past I have seen numbers get inserted that don't match the field definition. I just tested using Apex, Workbench and Jitterbit to insert records and they all were rounded when viewing them in the web ui. I then added a trigger to capture the values before and after insert. The values have the decimals. Finally I inserted a record with decimals and then queried it using Apex and SOQL. The value is stored with the decimal! So, it looks like Salesforce has changed the display to match the definition, but they are stored in the database as inserted.

[SalesForce] How to assign Custom Picklist value to a Custom field

Iterate through the picklist options, find the selected and cast the value (which is the label of the picklist in your case):

for (SelectOption selOption : pickList)
{
    if (selOption.getValue() == selectedId)
    {
        myObj.Specific_Discount__c = Decimal.valueOf(selOption.getLabel());
    }
}

Best Answer

Related Solutions

[SalesForce] Controlling the data type of a custom field

[SalesForce] How to assign Custom Picklist value to a Custom field

Related Topic