Forum Discussion

WaynePendley's avatar
WaynePendley
Qrew Trainee
8 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
8 years ago
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
    8 years ago
     Thanks, Coach.  I will explore these options.