302 Found

Found

The document has moved here.

Knowledge Base

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 (more details about summary fields can be found here: http://www.quickbase.com/help/default.html#create_summary_field.html) 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.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.