{"id":4954,"date":"2012-12-21T10:54:39","date_gmt":"2012-12-21T16:54:39","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=4954"},"modified":"2017-12-19T16:39:22","modified_gmt":"2017-12-19T22:39:22","slug":"creating-total-level-calculations","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/m-painter-app-prop\/creating-total-level-calculations","title":{"rendered":"Creating Total Level Calculations"},"content":{"rendered":"<p><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/1d0Zk1pVAK0\" height=\"315\" width=\"560\" allowfullscreen=\"\" frameborder=\"0\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>On the m-Power hotline, we sometimes field calls from developers who are trying to compute values based on subtotal or grand total values within their Reports. As you already know, m-Power Report templates, by default, will always add values vertically to compute sub-total and grand total values.<\/p>\n<p>As you can see here, m-Power is determining these values simply by adding up all of the detail values in this section to derive the subtotal value.\u00a0However, when working with values that divide, including percentages, the typical method to determine subtotal and grand total values will not apply.<br \/>\nOnce again m-Power is adding up these values. However, since they are percentages I do not want them to be summed. Instead I\u2019d rather have the values be determined at the subtotal level, that is to say horizontally, or \u00a0East to West.<\/p>\n<p>To accomplish this, Instead of creating my calculation in the m-Power interface, which will create the calculation at the detail level, I can use the Total Level Calculator within m-Painter to achieve this.<\/p>\n<p>Open m-Painter, then click on the cell where you want your total level calculation to live. First delete the existing field, then click the Calculator icon, then specify the necessary\u00a0fields, from the proper location.<\/p>\n<p>Once your application has been saved, please run it. Notice now that this value is no longer be determined based on the sum of the column, but instead is being computed from the values listed on the grand total level directly.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; On the m-Power hotline, we sometimes field calls from developers who are trying to compute values based on subtotal or grand total values within their Reports. As you already know, m-Power Report templates, by default, will always add values vertically to compute sub-total and grand total values. As you can see here, m-Power is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1410,"menu_order":10,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-4954","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/4954","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/comments?post=4954"}],"version-history":[{"count":3,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/4954\/revisions"}],"predecessor-version":[{"id":8779,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/4954\/revisions\/8779"}],"up":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1410"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/media?parent=4954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}