Figure 3. It All Has to Add Up.
This complex validation is used when multiple authors split the royalties for a book. The percentage royalty must add to 100 percent. If it doesn't add up, this validator flags all the rows for a given title with the error. A user may fix any of the values to make the total add up to 100 percent. The validator then clears the errors for all rows associated with that title.