{"id":14566,"date":"2025-03-18T18:05:22","date_gmt":"2025-03-18T23:05:22","guid":{"rendered":"https:\/\/www.mrc-productivity.com\/docs\/?post_type=ht_kb&p=14566"},"modified":"2025-03-20T10:30:01","modified_gmt":"2025-03-20T15:30:01","slug":"insert-running-total","status":"publish","type":"ht_kb","link":"https:\/\/www.mrc-productivity.com\/docs\/knowledge-base\/insert-running-total","title":{"rendered":"Insert Running Total"},"content":{"rendered":"\n
\n
\n
\"\"\/
Figure 1 – Insert Running Total button, highlighted<\/figcaption><\/figure>\n<\/div>\n\n\n\n
\n

A running total, also known as a cumulative sum, is the sum of a sequence of numbers or values as you progress through a dataset. In the case of an m-Power application, this is calculated by adding a value from the current row to the sum of the previous row(s) values.<\/p>\n\n\n\n

The ability to compute a running total option is available from the m-Painter editor<\/a>. Once a TABLE CELL element has been clicked in the m-Painter editor, the “Insert Running Total” option will appear, as shown in Figure 1.<\/p>\n<\/div>\n<\/div>\n\n\n\n

Walkthrough<\/h2>\n\n\n\n

Using a regular report template for example, a running total can be added to the end of the report to show a running total of the Quantity Ordered, for each detail record.<\/p>\n\n\n\n

\"\"\/\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
Figure 2 – Example report<\/figcaption><\/figure>\n\n\n\n

Inserting a running total<\/h3>\n\n\n\n

From m-Painter, the running total can be inserted into a new column of the presentation, or into an existing column already in the report. <\/p>\n\n\n\n

In either case, a table cell must be selected first and then the “Insert Running Total” option will be selected, as shown in Figure 3. <\/p>\n\n\n\n

\"\"\/\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
Figure 3 – Using the “Insert Running Total” option from m-Painter<\/figcaption><\/figure>\n\n\n\n

In the popup window that appears, the developer will configure the running total feature.<\/p>\n\n\n\n

\"\"\/\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
Figure 4 – Running total configuration<\/figcaption><\/figure>\n\n\n\n

The two options shown in Figure 4 are as follows:<\/p>\n\n\n\n

    \n
  • Field to Total<\/strong> – This is required. Select the numeric field which will be computed as a running total.<\/li>\n\n\n\n
  • Reset the total each time this field’s value changes (Optional)<\/strong> – If the running total should reset back to 0 based on another field in the application, then select that dependent field here. By not selecting a dependent field, the running total will continually sum until the last record on the page is reached. <\/li>\n<\/ul>\n\n\n\n

    In the example presented above, the field to be running totaled is the quantity ordered and no dependent field is selected. <\/p>\n\n\n\n

    After pressing “Apply” the m-Painter editor will display some logic in the cell to indicate a running total value has been placed, such as this:<\/p>\n\n\n\n

    {runningTotal(row,\"OQTY\")}<\/code><\/pre>\n\n\n\n
    Editing or Deleting a running total<\/h3>\n\n\n\n
    If needing to edit the running total configuration ever, click on the code in the cell. m-Painter will identify the element as a “DATA-FIELD”, where then the option to press “Edit Running Total” will appear, as shown in Figure 5.<\/p>\n\n\n\n
    \"\"\/\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
    Figure 5 – Edit or Delete a running total<\/figcaption><\/figure>\n\n\n\n
    To delete a running total value, select the trash can icon to perform the deletion of the DATA-FIELD element; which in this case is a running total value. Use Figure 5 for a visual clarification.<\/p>\n\n\n\n
    Runtime Demonstration (finished example)<\/h2>\n\n\n\n
    At runtime, the running total feature will look similar to this, where the numeric field (in this case, quantity ordered) is continually summed on each new detail record:<\/p>\n\n\n\n
    \"\"\/\n\t\t\t\n\t\t\t\t\n\t\t\t<\/svg>\n\t\t<\/button>
    Figure 6 – Finished example with a running total.<\/figcaption><\/figure>\n\n\n\n
    <\/p>\n","protected":false},"excerpt":{"rendered":"
    Figure 1 – Insert Running Total button, highlighted A running total, also known as a cumulative sum, is the sum of a sequence of numbers or values as you progress through a dataset. In the case of an m-Power application, this is calculated by adding a value from the current…<\/p>\n","protected":false},"author":2,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[255],"ht-kb-tag":[],"class_list":["post-14566","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mpainter"],"_links":{"self":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/14566","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/comments?post=14566"}],"version-history":[{"count":7,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/14566\/revisions"}],"predecessor-version":[{"id":14573,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb\/14566\/revisions\/14573"}],"wp:attachment":[{"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/media?parent=14566"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-category?post=14566"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/www.mrc-productivity.com\/docs\/wp-json\/wp\/v2\/ht-kb-tag?post=14566"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}