You need to sign in to do that
Don't have an account?
U Jay
Decimal/ Currency value formatting : Replace dot with comma
I have to replace . With , in from the decimal / currency value within visualforce page using output text without output field.
<apex:outputPanel rendered="{!localeValue != 'Eng'}">
<apex:outputText value="{!countryCurrencySymbol} {!SUBSTITUTE(TEXT(additionalCost.Actual_Price_without_Discount__c),'.',',')}" rendered="{!NOT(ISNULL(additionalCost.Actual_Price_without_Discount__c))}"/>
</apex:outputPanel>
This is my code. Replacement took plae nicely. But the terminating zeroes will not display.
Value in db = 12.30
Value displayed = 12,3
value required = 12,30
Value in db = 12.34000
Value displayed = 12,34
value required = 12,34000
What change i should make?
<apex:outputPanel rendered="{!localeValue != 'Eng'}">
<apex:outputText value="{!countryCurrencySymbol} {!SUBSTITUTE(TEXT(additionalCost.Actual_Price_without_Discount__c),'.',',')}" rendered="{!NOT(ISNULL(additionalCost.Actual_Price_without_Discount__c))}"/>
</apex:outputPanel>
This is my code. Replacement took plae nicely. But the terminating zeroes will not display.
Value in db = 12.30
Value displayed = 12,3
value required = 12,30
Value in db = 12.34000
Value displayed = 12,34
value required = 12,34000
What change i should make?
You can add formatting also in output text, please check with below example adn let me know if that works for you..
<apex:outputText value="{0, number, $###,##0}" ><apex:param value="{!objMemberInformation.SSA_Balance__c}"/></apex:outputText>