Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Before we start dragging data to the canvas, let's define a function to put city, state, and postal code (zip) together in the USA format. Select Data->Add Function->Common->Open Formula and insert the formula:

Code Block
 = [CITY]] & ", "& [STATE] & " " & [POSTALCODE]

...