I am new to Salesforce and i am trying to identify i way we can have a custom field on the Contact record to identify if someone is a "Single Purchaser" / "Multiple purchaser" or a "Non Purchaser".
We have an object called "Closings" once the status of this object reaches "Exchanged" then it is considered a sale. I would like to create a field that looks at the number of Exchanged closings the contact has, if the value is 0 then the field shows Non Purchaser, if the value is 1 it should show Single Purchaser and if the value is greater than 1 then it should show Multiple Purchaser.
Can anyone advise on how to achieve this ??