Testing a formula table
Before you begin
If you have not already done so, open the Formula Table window and then display the formula table you want to test.
-
Open the Formula Table window in one of the following ways:
- On the ribbon, from the Data tab, click . group on the
- In classic view, click Database menu > Formulas > Formula Tables.
- Click and select the formula table you want to work with.
To test a formula table:
-
Click [Test].
-
Enter values for each of the variables listed in the Test Formula Table window. Use values that will produce a result you can verify rather than random values.
Click [Total] or press Enter from the last variable to display the result.
-
Check the result displayed in the Total text box.
You can use the Sage Estimating (SQL) calculator to check the result. For more information, see Using the calculator to check a formula.
-
When you finish testing the formula table, click [Close] to return to the Formula Table window.
- Did your formula table
calculate properly?
- Yes. Congratulations, you are done!
- No. Change the formula table as needed, and then test it again.