Example Formula

A user wants to create a "Yet To Buy" column that calculates 7% of the Assigned Budget column. To create this formula using the keypad in the Formula Creation window:

  1. Click 7 and then click the percent % key. The value is displayed as 7/100.
  2. Click the multiplier X.
  3. Select Assigned Budget from the Cost Column pane on the left, and then click Select.

The final formula looks like this: 7/100 * Assigned Budget



Last Published Monday, October 7, 2024