OrgChart Now Help Guide

Tenure Example

Audience:

Audience: Administrators

Overview

OrgChart Now 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 More > Chart Settings, and then select the Field and Formulas option from the left side menu.

    5_2_1_CS_FieldsandFormulas_Arrow.png
  3. Click on the green f(x) Create button (in the top left corner). The Static Formula Editor panel is displayed.

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

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

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

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

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

  9. 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).

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

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

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

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

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

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

  16. Click on Save.

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