You need to sign in to do that
Don't have an account?
vandana raju
conditional report
Hi
I have some historical records in account object where the Phone field in some records is less than 10 digits and in some records it is 10 digits.
I need to show in a report only those records whose Phone is exactly 10 digits and not less.
Pls let me know how to achieve this.
Thanks
Vandana
I have some historical records in account object where the Phone field in some records is less than 10 digits and in some records it is 10 digits.
I need to show in a report only those records whose Phone is exactly 10 digits and not less.
Pls let me know how to achieve this.
Thanks
Vandana
All Answers
First create a formula field for account object which checks the length of the Phone number. Then create report for account object and add that formula check. In the filter, check whether the length of the digit is equal to 10. Then generate report.
Hope it works. If you are not getting, Please let me know.
Regards
Roshni
Creating a formula field worked.
There is one more thing I want to know.
I have phone field in the format (512) 757-6000.
How to display in report this format and also length should be 10 digits.
Using formula field in above case doesnt display the above format
Thanks
Vandana
Thanks, that worked.
LEN(SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(Phone, '.', '') , ' ', '') , '-', '') , ')', '') , '(', '')).
This shoul be your formula field because your phone number willbe displayed as" (822) 922-3223" . Inorder to avoid the special characters you have to use SUBSTITUTE.
Happy coding.
I tried and it works perfectly for me.Try it.
If it works, mark my answer as Best Answer.
Thanks
Roshni