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 […]
Browse:
- Home
- Calculations
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 […]
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 […]
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 […]
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
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)