You need to sign in to do that
Don't have an account?

Auto caluculate Max value of Text field formula
Hi All,
Here is my requirement: i have field called Source_code__c in Metadata_source__c Object. Field type is "Text". from Source_code__c Field I have to select Maximum value and i have to TRIM first 5 Charecters. after that with Remaining Value i have to add +1 to that Value. How can i achieve this, please anyone can help me.
Eg: Values of the Source_code__c= ABCDE1234 and ABCDZ1234 that means I have to get the value ABCDZ1234, From this value i have to TRIM or remove ABCDZ and Add+1 to 1234.
The Out put will be=1235.
I tried with creating new formula field For TRIM the Value but How can I select wich is the highest value and i dont know how to convert this string to Number in one Formula.
Formula is
anyone can please help me.
Advance Thanks!!
Here is my requirement: i have field called Source_code__c in Metadata_source__c Object. Field type is "Text". from Source_code__c Field I have to select Maximum value and i have to TRIM first 5 Charecters. after that with Remaining Value i have to add +1 to that Value. How can i achieve this, please anyone can help me.
Eg: Values of the Source_code__c= ABCDE1234 and ABCDZ1234 that means I have to get the value ABCDZ1234, From this value i have to TRIM or remove ABCDZ and Add+1 to 1234.
The Out put will be=1235.
I tried with creating new formula field For TRIM the Value but How can I select wich is the highest value and i dont know how to convert this string to Number in one Formula.
Formula is
TRIM(RIGHT(SOURCE_CODE__c,4))I want add the Formula Covert along with this Formula.
anyone can please help me.
Advance Thanks!!
TEXT(VALUE(TRIM(RIGHT(AccountNumber,4)))+1)
Here, value is to convert the text to number, then add 1, then convert back to text again because the data type you defined is Text.
I did not quite get the requirement of getting the maximum value, you mean there are multiple values for Source_code__c field?
Thanks for replying,
your right Source_code__c field have many values but i have to pick the Maximum value. field data type is Text it contains value like ABCDE1234 or ABGFZ1256. from this i have to get Maximum value.
I will try with above code, let you know the update
I have the similar requirement, plesae can you explain how was you implemented thi srequirement.
Thanks,
Sukanth Reddy