I have a text that get popluated with value like "$12,345.67", I have created a formula field currency
VALUE (MID( Text Field,2,Len(Text Field) ))
But i am getting error on the forumla field. Please help!
This is for reporting Purpose.
2 个回答
Try this: VALUE( LEFT( SUBSTITUTE(SUBSTITUTE(TextField__c,"$",""),",",""), FIND(".",SUBSTITUTE(SUBSTITUTE(TextField__c,"$",""),",",""))-1 ) )
+
VALUE(RIGHT( TextField__c, LEN(TextField__c)-FIND(".",TextField__c) )) /
CASE(LEN(RIGHT(TextField__c, LEN(TextField__c)-FIND(".",TextField__c))),
1,10,
2,100,
3,1000,
1)
