GETNORTHING

Returns the distance, in metres from the OSGB reference point, near the Scilly Isles, due North to the postcode sector centroid for the provided postcode.

GETNORTHING ( <field_name or postal_code> )
  • field_name or postal_code: The geographic field to extract the northing from.

Example: Create a field at the HOUSEHOLD level that returns the northing for each record.

GETNORTHING(HOUSEHOLD.POSTCODE)