Currently they provide us with a Budget Field ( TEXT ) that comes from an outside system into Salesforce, with Values such as ($1,500 or $650).
We are created a Formula Field with Type as Number with the following formula=
VALUE(SUBSTITUTE(mavenlink__Price__c, LEFT(mavenlink__Price__c, FIND('$', mavenlink__Price__c)) , ''))
This works fine for the $650 example but does not return anything for the $1,500 due to the comma.
We need to remove the comma out of the orginal fields as well and can not figure out how to add that using MID option as well.
We need this for reporting, as salesforce will not allow summary level formulas on Text Fields.
2 réponses
We were able to resolve the issue with the below formula: Formula Field type= Number
VALUE(SUBSTITUTE(SUBSTITUTE(mavenlink__Price__c,"$", ""),",", ""))
