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
  • Runtime Calculations
Back to Manual

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'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.

First, we will need to build our report, being sure to utilize the Report template.

Once the report is compiled, open the report within m-Painter.

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.

Click the "Calc" icon in the top toolbar. You should then see the below window:

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 "Add" to add each field to the calculation expression and insert your desired arithmetic. Give the calculation an appropriate length and edit code and press "OK".

Hit the "Save and Deploy" icon.

At run time, my grand-total output would look similar to this:

Our runtime calculation has calculated a profit of 85.70%.

Created: February 29, 2008 | Modified: August 18, 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

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

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.