OrgChart Now Help Guide

Arithmetic Examples

Audience

Audience: Administrators

Overview

Arithmetic formulas allow administrators to do basic math using the fields available in the source data.

The following section provides step-by-step instructions for creating a Total Bonus formula using the Multiplication operation.

Creating a Multiplication Formula

  1. Sign in to OrgChart.

  2. Click on More > Chart Settings, and then select the Fields & Formulas option from the left side menu.

    5_2_1_CS_FieldsandFormulas_Arrow.png
  3. Click the green f(x) Create button (in the top left corner) to create a new formula. The Static Formula Editor is displayed.

    5_2_1_CreateFormula_Panel.png
  4. Enter a name (i.e., Total Bonus) for the formula in the Formula Name textbox.

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

    TotalBonus_Concat.png
  6. Click on the Type dropdown menu, and then select the Field Lookup option.

  7. Click on the Value dropdown menu, and then select the field that you would like to multiply (i.e. Salary).

    TotalBonus_ConcatConfig.png
  8. Click the Plus_New_Blue_Wide.png icon (in the Operations panel), and select Concatenate.

  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 in your data set (i.e., Bonus Multiplier) by which you would like to multiply the previously concatenated field.

    Note

    Note: If you do not have a field within your dataset that contains the values by which you want to multiple the previously concatenated field, you can set the Type dropdown menu to Text, and then enter a value in the Value text box.

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

  12. Click on Save. The formula is added to the list of Fields & Formulas.

  13. Mouse over the newly added formula, 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.

  15. Optionally, add a prefix, elect to use the 1000 separator, or select how many decimal places to include in the outcome.

    MultiplyFormula_FieldEditor.png
  16. Click on Save.

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