{"id":1460,"date":"2008-02-29T03:45:21","date_gmt":"2008-02-29T09:45:21","guid":{"rendered":"http:\/\/www.mrc-productivity.com\/legacy\/?page_id=1460"},"modified":"2017-08-18T09:33:50","modified_gmt":"2017-08-18T14:33:50","slug":"using-the-run-time-calculator","status":"publish","type":"page","link":"https:\/\/www.mrc-productivity.com\/legacy\/m-painter-app-prop\/using-the-run-time-calculator","title":{"rendered":"Runtime Calculations"},"content":{"rendered":"<h1>Runtime Calculations<\/h1>\n<p>Runtime Calculations are ideal for customers who wish to perform calculations like averages at the Subtotal Level, or finding a percent of a of Grand Total.  For instance, let&#39;s say that we would like to pull up a list of Products and see their Month to Date units sold.  I would also like to know, based upon the grand total of all units sold, what is the profit margin for all sales on the grand total level.<\/p>\n<p>First, we will need to build our report, being sure to utilize the Report template.<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/legacy\/images\/runtimecalcs1.jpg\" \/><\/p>\n<p>Once the report is compiled, open the report within m-Painter.<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/legacy\/images\/runtimecalcs2.jpg\" \/><\/p>\n<p>Insert your cursor into the field where you would like to output the Grand Total (or subtotal) calculation.  In this example it will be the lower right cell.<\/p>\n<p>Click the &quot;Calc&quot; icon in the top toolbar.  You should then see the below window:<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/legacy\/images\/runtimecalcs4.jpg\" \/><\/p>\n<p>To create your calculation, choose your fields from the dropdown selection on the right.  Be sure to select the appropriate output level (Grand Total or Subtotal).  Click &quot;Add&quot; to add each field to the calculation expression and insert your desired arithmetic.  Give the calculation an appropriate length and edit code and press &quot;OK&quot;.<\/p>\n<p>Hit the &quot;Save and Deploy&quot; icon.<\/p>\n<p>At run time, my grand-total output would look similar to this:<\/p>\n<p><img decoding=\"async\" class=\"border\" src=\"\/legacy\/images\/runtimecalcs5.jpg\" \/><\/p>\n<p>Our runtime calculation has calculated a profit of 85.70%.<\/p>\n<p><!-- End Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Runtime Calculations Runtime Calculations are ideal for customers who wish to perform calculations like averages at the Subtotal Level, or finding a percent of a of Grand Total. For instance, let&#39;s say that we would like to pull up a list of Products and see their Month to Date units sold. I would also like [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":1410,"menu_order":9,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1460","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1460","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=1460"}],"version-history":[{"count":9,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1460\/revisions"}],"predecessor-version":[{"id":8601,"href":"https:\/\/www.mrc-productivity.com\/legacy\/wp-json\/wp\/v2\/pages\/1460\/revisions\/8601"}],"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=1460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}