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

Calculations

The Calculations specification is an important tool in designing applications, allowing you to create new fields to work with in subsequent calculations, record selections, and external objects. Through calculations, you can create numeric and character expressions, call database functions, and perform conditional logic.

calculations

Input Fields:

Field Name- When creating new fields in summaries, you need to specify a field name. This name will be the name of the field in the database.

Calc Type- Select your calculation type from the dropdown:  database, system value, parameter, application, or external object. Database calculations are the most common calculation type, and will meet the needs of most new m-Power developers. For more information on calculation types, click here.

Description- Enter a description of the field that will appear in your application.

Data Type- Select either numeric, alpha, or date.

Length- Specify the length of your field.  Remember that the calculation may change the expected field length, and in some instances it is a good idea to have a small buffer.  Note:  the length includes the length of the decimal, and extra digits will automatically be trimmed.  For instance, 45.342 will have a length of 5, and a decimal of three.

Format- Select the desired format.  m-Power comes equipped with commonly used numeric and date formats. However, you can also design your own formats.

Round- If set to yes, the decimal  portion of the value will round up if the decimal is greater than or equal to .5 , otherwise the value will round down.  If rounding is set to no, the decimal will truncate depending on the specified length.

Calculation- Input your calculation in the largest input box.  You may type in your calculation or use the calculator provided.  The fields and functions available to use will depend on the calculation type.

Conditions

m-Power is equipped to add conditions to calculations. Data that matches the requirements of the condition will process the calculation. To add a condition, click Add New. This opens the Conditions box.

calculations_conditions2

Select the desired field and relationship from the respective drop down lists, and enter a value.  Finally, select either "And" or "Or" from the final drop down.  Selecting "And" will require the subsequent condition to also meet the required relationship for the calculation.  Selecting "Or" will allow the calculation to process if either of the conditions are met.

For more information on calculations, please click here.

Created: July 15, 2013 | Modified: June 12, 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

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

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.