Existing fields and new fields

Now that you've created targeted subsets of the original data by applying filters to obtain data that has a year built, gross square feet, a sale price greater than $100,000 and a unique address, additional research can be applied.

Your supervisor would like to format the RecordID field by adding leading zeroes to match the existing field within a database. They are also interested in finding the highest sale price per gross square foot of this updated property dataset.

The Formula tool is a perfect solution for updating the existing RecordID field, and creating a new calculated field of "Price per Sq Ft"!

If you lost any progress, load the 2_3_sort_and_unique_solution.yxmd from the Exercises folder on the Desktop.