Apex:OutputText to Currency Format from String Wrapper

Question

is there a way to pass a string to the <apex:outputText> so that it can be formatted as a currency or percent value?

Here's what I have inside a column of my visual force table:

<apex:outputText value="{0, number, currecny}">
<apex:param value="{!row.values[1]}" />
</apex:outputText

this gives me an error at runtime (when the visual force page loads), which I think may be some kind of type mismatch, where <apex:outputText> is expecting a Decimal or number but I am passing a string.

This is the error at runtime:

The value attribute on is not in a valid format. It must be a positive number, and of type Number, Date, Time, or Choice.

Thanks

Answer 1

The problem was you misspelled currency. This works fine and avoids hard coding the currency symbol:

<apex:outputText value="{0, Number, Currency}">

Answer 2

From my comment:

<apex:outputText value="${0, number, ###,###,##0.00}"> works as well. The hashes display numbers in that position if they exist. So it will display $3.14 instead of $000,003.14 as in the example using ${0, number, 000,000.00}

Answer 3

You need to use <apex param> along with <apex:outputText> by specifying the proper parameters for it to be output in. Here's an example from the VF Developer's Guide:

<!-- For this example to render properly, you must associate the Visualforce page
with a valid account record in the URL.
For example, if 001D000000IeChM is the account ID, the resulting URL should be:
https://Salesforce_instance/apex/myPage?id=001D000000IeChM
See the Visualforce Developer's Guide Quick Start Tutorial for more information. -->

<apex:page standardController="Account">
It is worth:
<apex:outputText value="{0, number, 000,000.00}">
<apex:param value="{!Account.AnnualRevenue}" />
</apex:outputText>
</apex:page>

This would render as

It is worth: 500,000,000.00

Were I doing this, I'd be adding the currency symbol in with the outputText value as below:

<apex:outputText value="$&nbsp{0, number, 000,000.00}">

This would render as

It is worth: $500,000,000.00

Answer 4

The Best Solution for the above problem is:

<apex:outputText label="NRR" value="{0,number}">
{! Opportunity.CurrencyIsoCode} &nbsp;
<apex:param value="{! Opportunity.NRR__c}" />
</apex:outputText>

This is give you the Currency (CurrencyIsoCode) as well as the value (in proper format) if it exists in the field value.