Reply to comment

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.

Reply

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.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit