mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • m-Painter
  • Creating Total Level Calculations
Back to Manual

 

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 determining these values simply by adding up all of the detail values in this section to derive the subtotal value. However, when working with values that divide, including percentages, the typical method to determine subtotal and grand total values will not apply.
Once again m-Power is adding up these values. However, since they are percentages I do not want them to be summed. Instead I’d rather have the values be determined at the subtotal level, that is to say horizontally, or  East to West.

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.

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 fields, from the proper location.

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.

Created: December 21, 2012 | Modified: December 19, 2017

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Application Properties Java Bar Graphs Freemarker Performance Dates Build Process Administration Popular Database Calculations Prompt Screens Retrievals Security Record Selections Compiling App Properties Form Validation Summaries Retrieval Excel RPG Dropdowns Maintainers Graphs Reports mrc-Productivity Series Maintainer Admin DB2 Report Getting Started Video Graphing SQL Tomcat Parameters Data Dictionary Production External Objects Graph Properties Advanced Email Bootstrap Templates m-Painter

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.