Learn more

Changing an existing formula

Setting up a new formula

Hints on building formulas

Formula window

Formulas command

Use this command (Data tab, or in classic view, Database menu) to create, edit, and test individual formulas in the standard database. This command opens the Formula window where you can enter the name, unit of measure, equation, and notes for each formula. Formulas is available only when a standard database is open.

With Sage Estimating (SQL), you can easily create formulas, no matter how complex, using standard algebraic logic. If you attach a formula to a standard database item, Sage Estimating (SQL) uses that formula to calculate the takeoff quantity for the estimate. 

Tips:  

  • Edit Formula is often available on a button or on the shortcut menu when you are working with formulas in other windows.
  • Use the Options command if you want the Formula window to remain in add mode after you save each new record.