Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.
How can I use a column or field total from a table in a formula field?
QuickBase formulas can be used within a record to compute and return a value. Generally formulas can only be used within a single record and can not span across multiple records in a table. For instance, in an employee table with a field Salary, the Salary for individuals can not be computed as a percentage against all other employees' salaries. One could however, take an employee's bonus and compute that as a percentage of the employees total income, as all this information resides in the single employee's record.
In some cases, it may be helpful to know that a summary field in a master record can be used in formulas. For instance, a manager may wish to know what percentage of his/her budget is used on salaried employees. In this case, the master record (manager) will have a summary field (To learn more, please see our Create a Summary Field help topic) that returns the total of all the salaries for employee records related to the manager master record. If there's another field called Budget in the manager record, then the percentage could be computed in a Formula -Numeric field called "Percent of Budget Salaried" with a formula similar to the following:
[Total Salaries] / [Budget]
Additionally, computed values in Summary or Crosstab views can not be referenced by QuickBase formulas.