Forum Discussion

WaynePendley's avatar
WaynePendley
Qrew Trainee
7 years ago

How to prompt the user if the sum of specified fields is not equal to 100% ?

We want to include some automatic checking of date entry errors, and in one of our apps we need to have the sum of several fields that the user enters total to 100%.  What are some efficient ways to p...
App builders
Formulas and functions
Tips and tricks
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
One solution is to have the last field be a formula field equal to 1 - the sum of the other fields. Then it will always total to 100%. That sound like your best solution.

The other method is to have two messages controlled by an IF statement. There can be a red message saying the total and saying it does not add to 100, and a green message saying Totaks OK.

Let me know if you need help with the color formula.
WaynePendley's avatar
WaynePendley
Qrew Trainee
7 years ago
 Thanks, Coach.  I will explore these options.