USING IF -THEN -ELSE WITH PICTURE FUNCTION 1

[JULY1]

I am using the following as my formula for phone numbers:

picture({CallDetailRecord.callingPartyNumber},"XXX-XXX-XXXX&quot

My problem is that this is picking up our 5 digit extensions (ex. 15330) as 153-30-.

How can I set up a formula to use the "XXX-XXX-XXXX" when there are ten digits to the phone number, and then to use "XXXXX" when there are five digits (for extensions).

 

[synapsevampire]

Try creating a formula to display it using:

if len(trim({table.phone})) = 10 then
picture(phone,"XXX-XXX-XXXX&quot
else
if len(trim({table.phone})) = 15 then
picture(phone,"XXX-XXX-XXXX-XXXXX&quot
else
"Invalid"

-k