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 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, then click Select

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



Last Published Monday, August 28, 2023