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 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
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Overview Training Project Consulting Staff Consulting 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
  • Calculations

Creating Total Level Calculations

  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 […]

Tags: Calculations, m-Painter, Popular, Video

Working with Lengthy Fields

Working with Lengthy Fields   m-Power has always easily handled fields of lengths less than 1000 characters. Beginning with the August 20th, 2012 update, fields of any length can be used within m-Power. When registering tables, simply add them as normal and the proper field lengths will be registered: Calculations also now support large field […]

Tags: Calculations, External Objects

Suppressing Calculation Error Messages

Suppressing Calculation Error Messages   When a developer creates a calculation, m-Power automatically takes the syntax of this calculation and attempts to run it directly on the database. If the database returns an error message, m-Power notifies the developer of the specific database error, and the developer has the opportunity to update their calculation syntax […]

Tags: Calculations, Error Messages, Popular

Calculation Screen

Calculation Screen Calculation Features Calculation Types Creating Calculations Calculation Features Calculations as Sequence keys and Record Selection fields — Calculations have been designed to take full advantage of SQL. Nearly every calculation is available to use as a sequence field or record selection field. Sequence/Record Selection Availability — The Work-with Calculation screen shows which calculations […]

Tags: Application Calculations, Calculations, Conditional Calculations, Database Calculations, Dates, External Objects, Parameter Calculations, SQL, System Variables

Add/Subtract Dates using the Java Date Translator

Add/Subtract Dates using the Java Date Translator **Note: This Feature Has Been Deprecated. Please use this link to find alternative features: https://www.mrc-productivity.com/techblog/?p=522     The Java Date Translator is a very powerful tool, commonly used to determine the difference between two dates (Most date conversion can now be accomplished with a UDF). However, there is […]

Tags: Calculations, Dates, Java, Java Date Translator

Conditional Calculations

Conditional Calculations   Conditional Calculations are a great tool to be able to customize your application and take them to the next level. Some examples of conditional calculations could be: To control the color of individual data. For instance, you could divide data output into three different color groups: red (for low performing values), yellow […]

Tags: Calculations, Conditional Calculations

Displaying System Variables at Run Time

Displaying System Variables within a Web Application   There are numerous times when a developer needs to display System Variables within a Web Application. This can be done easily through the calculation screen. Simply create a System Variable Calculation. Simply select "System Value" from the "Calc Type" dropdown list. Next, specify a description for this […]

Tags: Calculations, System Variables

Parameter Calculations

Parameter Calculations   Parameter calculations are a great technique when you are trying to pass a value between multiple applications. For example, you would like to pass a value from the prompt page or URL to the output page to determine some conditional calculations. In our case, our calculation would accept a value, then a […]

Tags: Advanced, Calculations, Parameter Calculations

Runtime Calculations

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 […]

Tags: Calculations, m-Painter, Popular, Runtime Calculator

Copy Calculations within m-Power

Copy Calculations   This feature allows you to copy preexisting calculations quickly within the same application. Whether you need to copy one or one hundred, this is an easy and effective way to mass produce similar calculations. Copying Calcs in Retrievals, Reports & Graphs, and Maintenance Applications Enter the Calculations screen and create a calculation […]

Tags: Advanced, Calculations

More Results »

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

See all tags »

michaels, ross & cole, ltd. (mrc)
Privacy Settings Privacy Policy Cookie Policy Employee Intranet
© 2023 mrc. All rights reserved.
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