Skip to main content

OrgChart Help Guide

Tenure Example

Audience:

Audience: Administrators

Overview

OrgChart allows Administrators to create a formula for calculating an employee's years of service. The following article provides step-by-step instructions for creating a Tenure formula.

Creating a Tenure Formula
  1. Sign in to OrgChart.

  2. Click on the Mode Switcher icon in the Top Toolbar, and then select the Setup option. The Setup panel is displayed.

    Setup_ChartSettings_Select.png
  3. Click on the Chart Settings tile, and then select the Fields & Formulas option from the left side menu.

    5_2_1_CS_FieldsandFormulas_Arrow.png
  4. Click on the green f(x) Create button in the top left corner, and then select the Static Formula option. The Formula Editor panel is displayed.

    5_2_2_Fields_and_Formulas__Select_Static_Formula.png
  5. Enter a name for the formula (i.e. Tenure) in the Formula Name text box.

  6. Click on the "No values. Click here to add." hyperlink, and then select the Concatenate option from the dropdown menu.

    TenureFormula_Concat.png
  7. Click on the Type dropdown menu, and then select the Date option.

    ConcatDate.png
  8. Click on the Plus_New_Blue_Wide.png icon (in the Operations panel), and then select the Concatenate option.

  9. Click on the Type dropdown menu, and then select the Field Lookup option.

  10. Click on the Value dropdown menu, and then select the field associated with the date of hire in your source data (i.e. Hire Date).

  11. Click on the Plus_New_Blue_Wide.png icon (in the Operations panel), and then select the Subtract option.

  12. Click on the Treat Value as dropdown menu, and then select the Date option.

    Tenure_Subtract.png
  13. Click on Save. The Tenure formula is added to the list of Fields and Formulas.

  14. Mouse over the Tenure, and then click on the Pencil_Edit_Icon.png icon. The Field editor is displayed.

  15. Click on the Field Type dropdown menu, and the select the Number option.

    StaticFormula_Tenure_EditField.png
  16. Optionally, click on the Decimal Places dropdown menu to select how many decimals places you would like shown in the field value.

  17. Click on Save.

  18. Click on Refresh, and then select the Yes option to preserve your changes.