About creating percentage columns

When you use a formula to create a column in Inquiry, you can specify whether the formula results in a percentage. This ensures that the percentages total correctly.

To specify a percentage, you must:

• First, enter a formula in the format of A/B or A/B * 100 in the Formula Editor window (for example, [Spent] / [Billed]).

• Then, select the Percent column check box on the Number Format tab of the Column Properties window.

If the Percent column check box is selected but the formula is not in the correct percentage format, an error message appears and you cannot save the column until you correct the formula or clear the Percent column check box.

For step-by-step instructions, see Creating a new inquiry column.