function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
TeddyAbleTeddyAble 

Convert Text to Currency?

Hello guys;

 

Is it possible to convert Text to Currency in dataType Formula

 

Fum__c (textfield) Fum2__c(textfield)

 

I will like to Add this field in a new formula return type to be Currency called  in aggFum__c

 

so basically aggFum(Fum__c+Fum2__c)

 

But Salesforce Says it is invalid .

 

Is there a way the formula can be rewritten to convert the text to currency so i can get the currency value ?

Best Answer chosen by Admin (Salesforce Developers) 
goabhigogoabhigo

If Fum__c and Fum2__c are always numbers (if yes I don't see the need of declaring them as text !!), then you can use the following formula:

 

VALUE(Fum__c) + VALUE(Fum2__c).

 

Does this help? Let me know...

All Answers

goabhigogoabhigo

If Fum__c and Fum2__c are always numbers (if yes I don't see the need of declaring them as text !!), then you can use the following formula:

 

VALUE(Fum__c) + VALUE(Fum2__c).

 

Does this help? Let me know...

This was selected as the best answer
TeddyAbleTeddyAble

Fum__c and Fum2__ are is a testfield but numbers are used in the text field.

 

Please Let me know if there is a way for me to add the two values and conver them.

 

Regards

 

Shukla_AnkitShukla_Ankit

Hi,

 

Try that formula on text fields

 

=value(Fum__c) + value(Fum2__c) 

 

Its may help you...

goabhigogoabhigo

What is different in your answer from my answer buddy??

TeddyAbleTeddyAble

Thank you guys