Calculations

Within a formula, you can perform a calculation.

Below are some sample calculations:

Field + Field: Total Compensation = Salary + Bonus 

Click to enlarge

Field * Value: Next Year Salary = Current Salary * 1.05 

Click to enlarge

Constant - Field: Year To Retirement = RETIREMENT AGE – Current Age  

Click to enlarge

Note: See Using Constants for more information on Constants.

You can also perform date calculations using the TODAY constant and/or the Year, Month, and Day functions.

Below are some sample date calculations:

Years_with_company: Today – Hire_Date 

Click to enlarge

Months_since_last_review: Today – Review_Date 

Click to enlarge

To define a calculation within a formula:

1        In the Formula tab of the Formula Properties dialog box, define the first argument type. The following types are available:

·         Field

·         Text

·         Number

·         Date

·         Date (Years)

·         Date (Months)

·         Date (Days)

·         Constant

2        Select or type an argument value.

3        Select a range. Available Formulas.

4        Select an operator (/, *, +, -).

5        Define the type for the second argument.

6        Select or type a value for the second argument.

Optionally, you can also define a third argument using the same procedure as noted in the steps above.

7        Click OK.

Note: If you want to hide formula results that are a zero value, you can select the Hide if 0 option in the Define Fields dialog box for formula fields. The field will not appear in the box if the returned value is zero. This setting is also saved when you save the chart as a template.