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

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

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

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

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: http://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 […]

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

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

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

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

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