• Pkirch
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

I have created a Cross object Custom formula field that displays the Address .Here is the format to display the address field.

 

 

Account.BillingStreet  & BR() &
Account.BillingCity & ", "
 & Account.BillingState  & " " &
Account.BillingPostalCode  & BR()
& Account.BillingCountry

 

Now my question is there is a Comma in the formula and it displays, when the BillingStreet,BillingCity,etc., fields are empty.

How to resolve this?