{"id":799,"date":"2022-08-22T12:37:46","date_gmt":"2022-08-22T12:37:46","guid":{"rendered":"http:\/\/markedcode.com\/?p=799"},"modified":"2023-12-22T16:33:01","modified_gmt":"2023-12-22T16:33:01","slug":"d365-form-column-summinmaxavg","status":"publish","type":"post","link":"https:\/\/markedcode.com\/index.php\/2022\/08\/22\/d365-form-column-summinmaxavg\/","title":{"rendered":"D365 &#8211; Form column Sum,Min,Max,Avg"},"content":{"rendered":"\n<p>In the latest version of D365 10.0.29, a new feature has been added to show aggregate field values on forms. This allows us to see averages, maximums, minimums, and sum totals. To see these values we can right click on our column and choose &#8216;View column total&#8217;. Then we can select one of the available options.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"278\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-4-300x278.png\" alt=\"Add aggregate column\" class=\"wp-image-802\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-4-300x278.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-4-768x711.png 768w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img1-4.png 1013w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>Choosing one&nbsp; option will populate a footer with aggregate information. The value displayed here can be changed by clicking on the name (&#8216;Average&#8217;) and selecting a different option form the available list.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"290\" src=\"http:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img2-4-300x290.png\" alt=\"View aggregate column\" class=\"wp-image-801\" srcset=\"https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img2-4-300x290.png 300w, https:\/\/markedcode.com\/wp-content\/uploads\/2022\/08\/img2-4.png 325w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/figure>\n\n\n\n<p>These new values can then be saved into personal views by users to easily keep track of this information in D365.<\/p>\n\n\n\n<p>Keep reading about D365 tips and tricks here: <a href=\"https:\/\/markedcode.com\/index.php\/category\/d365\/\">https:\/\/markedcode.com\/index.php\/category\/d365\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In the latest version of D365 10.0.29, a new feature has been added to show aggregate field values on forms. This allows us to see averages, maximums, minimums, and sum totals. To see these values we can right click on our column and choose &#8216;View column total&#8217;. Then we can select one of the available<\/p>\n","protected":false},"author":1,"featured_media":985,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[7],"tags":[29,26,28,27],"class_list":{"0":"post-799","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-d365","8":"tag-avg","9":"tag-d365-form-column-sum","10":"tag-max","11":"tag-min"},"_links":{"self":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/799","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/comments?post=799"}],"version-history":[{"count":3,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/799\/revisions"}],"predecessor-version":[{"id":1160,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/posts\/799\/revisions\/1160"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media\/985"}],"wp:attachment":[{"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/media?parent=799"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/categories?post=799"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markedcode.com\/index.php\/wp-json\/wp\/v2\/tags?post=799"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}