Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • The Community Treasure Chest
  • Complex Math and Date Formulae

Reduce Social Security Account Number (SSAN) to Final Four Digits

Written by Service Desk

Updated at October 12th, 2022

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Introductions to our Software
  • The Learning Curve, Three Training Courses
    The Readers' Digest Condensed Version In the Beginning, The Lesson Plan #1 The Lesson Plan, The Lesson Plan #2 The Learning Curve Basics, #1 The Learning Curve Intermediate Level, #2 The Learning Curve Advanced Level, #3
  • Installations and Emergencies!
    Installation Instructions Network, Unusual, Troubled, or Manual Installations Emergencies — What to do when things turn hot
  • Videos: Deep Dives on Specific Features
    Form Sets Doxserá DB and Its External Sources
  • Doxserá DB Library
    Doxserá DB, What can it do? Doxserá DB, How does it work? Doxserá DB, In-depth features and functions
  • Resource Library
    Guides and Manuals Video demonstrations of the Lessons in the Expert Guide Organizing Files, Folders, Documents, Templates… and Your Life Converting WordPerfect to Word
  • The Community Treasure Chest
    Truly Complex Roles Complex Math and Date Formulae Tidbits That Can Improve Your Experience Company Organization and Formation Oklahoma Dissolution Form Examples Sources: Master Lists, Spreadsheets, and other data sources Little Tools
  • Aurora
  • Word Warriors®
    About Micrsoft Word Tips & Tricks
  • News and Updates
    Staying up to date Current Versions of Our Software Updates for Doxserá and TheFormTool Archives
  • More
    All Things Mac, Linux, Tablets, and Other Items Miscellaneous Feature Requests
+ More

While SSANs aren't numbers in that they cannot be added or subtracted, there are times when treating them as though they are can be helpful. Extracting just the final four characters is one of those times.

In the Questionnaire, guide the data provider, the person answering the questions, to enter the SSAN in a single string of nine digits without hyphens, such as 123456789.

In the form, create a Field based on that Answer. First set the Format to (1000 no decimals), then choose the Nmbr radio button, and the Math tab.

In the Math window, select Remainder from the dropdown menu on the left side and use the green plus button to start to formula. Within the Remainder brackets, enter the Field selection from the left dropdown followed by the Label of the Question. After the comma enter 10000.

This is designed to divide the SSAN by 10,000 and then provide just the remainder, the final four digits, as the answer.

The screens should look like these:

Remainder.jpg

tags: remainder, truncate, number, integer, ssan, social security, confidential

final four reduce ssan

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • How to Compute a Monthly Lease Payment
  • Computing the Number of Years and Months
  • A complex but fun Calendar Offset solution to a difficult and high-error statutory document issue
  • Naming the Months Between Two Dates
Recent posts
  • Multi-Party, Multi-Role Decisioning
  • The Fastest Training
  • Inflation is Going to Grow, a Lot
  • The lowest-hanging fruit
  • Technical tidbits from TheFormTool, LLC
  • Improving Your Firm’s Support Structure
  • The Knowledge Base
Request for information

Submit

Recent Tweets
  • While TheFormTool remains amazingly easy to use, it's fully capable of managing truly complex document assembly nee… https://t.co/DHPPwcNv1M 6 days ago
  • It was in January 2021, that we first forecast massive inflation was coming our way. Whether it is called “quantita… https://t.co/Ab3MV1SLQz 26 days ago
  • Low-hanging fruit: the most often used features of document assembly systems. Automatically: perfect pronouns and p… https://t.co/A5rg6zRSd8 200 days ago
Copyright ©2012-2022 TheFormTool, LLC. All rights reserved.

Knowledge Base Software powered by Helpjuice

  • Home
  • Contact Us
  • Privacy
  • TheFormTool User License
  • Site Map
——— bottom-nav
Expand