![\"\"](\"https:\/\/help.insperity.com\/bps\/wp-content\/uploads\/sites\/3\/2021\/02\/image-71.png\")
<\/figure>\n\n\n\nComplete the following fields under Field Properties<\/strong>:<\/p>\n\n\n\n Once you have your formula created, press Save<\/strong>.\u00a0<\/p>\n\n\n\n Your new calculated field is available to use in your views and conditional formatting.\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":" Formula Fields Overview Insperity Organizational Planning can be configured to add custom formula fields that work with your data to create powerful insight to your company’s charts.\u00a0 Formula fields leverage the existing information in your data source and the attributes associated with each employee such as start date, birth date,…<\/p>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[],"class_list":["post-445","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-fields"],"_links":{"self":[{"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/ht-kb\/445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/comments?post=445"}],"version-history":[{"count":1,"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/ht-kb\/445\/revisions"}],"predecessor-version":[{"id":448,"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/ht-kb\/445\/revisions\/448"}],"wp:attachment":[{"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/media?parent=445"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/ht-kb-category?post=445"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.insperity.com\/bps\/wp-json\/wp\/v2\/ht-kb-tag?post=445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Display Name<\/strong>:\u00a0 Type the name you would like to call this field. This will also be the name of the field that will display by default on the box when adding to a view.\u00a0<\/td> <\/td> <\/td><\/tr> Description:<\/strong> (Optional) Type any descriptions for the formula field that will be helpful when reviewing the formula.<\/td> <\/td> <\/td><\/tr> Categories:<\/strong>\u00a0 Select the formula Category type
Number <\/em>– Use when you will be creating a formula based on numbers. \u00a0\u00a0Example, \u201cTotal Salary\u201d
Date<\/em>– Use when you want to use a date field to make the calculation. \u00a0Example, \u201cDays from hire\u201d
Lookup and Reference<\/em>– Use when you need OrgPlus to look up data in your data source. \u00a0Example, \u201cHeadcount\u201d \u00a0
Text <\/em>– Use when you are creating formulas from text values in a data source. \u00a0Example, \u201cFull Name\u201d from First Name and Last Name fields.<\/td><\/td> <\/td><\/tr> Functions<\/strong>:\u00a0 Select the function to apply to the calculation.
Date<\/em>– The following functions are for use with Date fields.
Date Add:\u00a0Adds the specified number of days, months, or years to a date.
Day: Return the day from the selected date field.
Month: Return the month (1-12) from the selected date field.<\/span>
Number of Days: Return the number of days between two dates.
Year: Return the year from the selected date field.
Lookup and Reference<\/em> – The following functions are for use with Lookup and Reference fields.
Count: Count the number of people within a range of boxes.
Level: Calculate the absolute level of a box.
Levels Below: Calculate the number of levels that exist below a box relative to the box’s level.
Occurrences: Calculate how often an individual or position occurs within a range of boxes.
Reports\u00a0To: Return the argument of the box’s manager
Number <\/em>– The following functions are for use with number fields.
Average: Compute an average of the selected number field for all specified boxes.
Calculate: Return the arithmetic computation (add, subtract, multiply, divide) of the selected field within a range of boxes.
Max: Determine the maximum value of the selected field across all boxes.
Min: Determine the minimum value of the selected field across all boxes.
Total: Add all the selected field within a range of boxes.
Text <\/em>– The following functions are for use with text fields.
Concatenate:\u00a0Joins several text strings and\/or fields into one text string.
Left: Return the specified number of characters from the start of a text string.
Length: Return the total number of characters in a text string.
Lower: Convert all letters in a text string to lowercase.
Mid: Return the characters from the middle of a text string, given a starting position and a length.
Right: Return a specified number of characters from the end of a text string.
Trim: Remove all spaces from a text string except for single spaces between words.
Upper: Convert all letters in a text string to uppercase. \u00a0<\/td> <\/td> <\/td><\/tr> Formula Creation<\/strong>: Based on what Category- Function you choose, you are to begin creating the argument to support the formula. This may be a series of field drop down selections.<\/td> <\/td> <\/td><\/tr> Formula Condition: <\/strong>\u00a0Apply this function if you would like to only apply the formula to certain employees who meet specific conditions, such as full time or part time.
(1) Check the box to allow the condition
(2) Create your condition by creating rules
Select the field that will decide the condition
Select the qualifying argument (equal to, is, is not..)
Then complete the qualifying condition
Example, \u201cEmployee Status\u201d is \u201cFull Time\u201d
(3)\u00a0 Click Okay<\/strong> when complete<\/td><\/td> <\/td><\/tr> Formula Operations: <\/strong> In this section you can change the defaults for rounding, including\/excluding assistants and matrixed employees.<\/td> <\/td> <\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n ![\"\"](\"https:\/\/help.insperity.com\/bps\/wp-content\/uploads\/sites\/3\/2021\/02\/image-72.png\")
<\/figure>\n\n\n\n