{"id":9917,"date":"2016-02-23T12:26:38","date_gmt":"2016-02-23T04:26:38","guid":{"rendered":"http:\/\/localhost\/help\/?page_id=9917"},"modified":"2020-11-11T17:29:16","modified_gmt":"2020-11-11T09:29:16","slug":"average","status":"publish","type":"page","link":"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/average\/","title":{"rendered":"Average()"},"content":{"rendered":"\n<h2><span id=\"Format\">Format<\/span><\/h2>\n<p class=\"intro-text\"><strong>Average(Number [,Numbers])<\/strong><\/p>\n<p class=\"left-bar-p2blue\">Note: This function was named\u00a0<em>Avg<\/em>\u00a0in v2.6.<\/p>\n<h2><span id=\"Returns\">Returns<\/span><\/h2>\n<p class=\"intro-text\">Returns the average value of the variable number of arguments.<\/p>\n<h2>Inputs<\/h2>\n<p class=\"intro-text\"><strong>Number<\/strong>: The argument\u00a0whose values should be averaged.<br \/>\n Behaviour: Required<br \/>\n Dimension: Collection, SingleValue<br \/>\n Valid\u00a0data types:\u00a0Decimal, Integer\u00a0<\/p>\n<p class=\"intro-text\"><strong>Numbers<\/strong>: Additional arguments whose values should be averaged.<br \/>\n Behaviour:\u00a0Optional (0..n)<br \/>\n Dimension: Collection, SingleValue<br \/>\n Valid data types: Decimal, Integer<\/p>\n<p class=\"left-bar\"><a href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/calculation-syntax\/#Data_Type\">How to format data types<\/a><\/p>\n<h2><span id=\"Examples\">Examples<\/span><\/h2>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Average(1,2)<\/span><br \/>\n Result: <span style=\"color: #0000ff;\">1.5<\/span><\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Average<\/span><span class=\"code-fragment\">(1,2,1)<\/span><br \/>\n Result: <span style=\"color: #0000ff;\">1.33<\/span><\/p>\n<p class=\"intro-text\">Expression: <span class=\"code-fragment\">Average<\/span><span class=\"code-fragment\">({Tag1}, {Tag2})<\/span><br \/>\n Result: Returns the average value of the two tags.<\/p>\n<p class=\"intro-text\">\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use Average() to get the average value of the supplied arguments.<\/p>\n<p class=\"continue-reading-button\"> <a class=\"continue-reading-link\" href=\"https:\/\/oihelp.corporate.ifs.com\/help\/p2-server\/calculations\/average\/\">Read more<i class=\"crycon-right-dir\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":9918,"parent":3650,"menu_order":12,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":"","_members_access_role":[],"_members_access_error":""},"categories":[9],"tags":[285,100],"class_list":["post-9917","page","type-page","status-publish","has-post-thumbnail","hentry","category-tech-ref","tag-average","tag-calculations","Product-srv"],"_links":{"self":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/comments?post=9917"}],"version-history":[{"count":1,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9917\/revisions"}],"predecessor-version":[{"id":46181,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/9917\/revisions\/46181"}],"up":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/pages\/3650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media\/9918"}],"wp:attachment":[{"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/media?parent=9917"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/categories?post=9917"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oihelp.corporate.ifs.com\/help\/wp-json\/wp\/v2\/tags?post=9917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}