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 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
  • Freemarker
  • HTML Edit Codes to Control Data Rounding
Back to Manual

Using HTML Edit Codes to Control Data Rounding

 

This documentation describes how to use HTML edit codes to hide a decimal field from view, while still allowing it to be used in calculating sub and grand total levels.

To begin with, be sure to use the Web 2.0 Report template when building your application.

So that you can easily see the difference, an application has been built, sequenced by State. Only one Numeric Field has been selected. For comparison purposes, a calculation has been used to replicate this numeric field.

Before any editing is done, my output looks like this:

Since this requires HTML editing, we must open m-Painter.

Right-click on your field at the detail level, and select "Cell" then "Edit Cell HTML". Replace ?html} with _o?string("$,##0")}.

Be sure to repeat the process for your field on the sub-total and grand-total rows.

Click the "Save" button & run your application. My output now looks like this:

Note: The Original Field was left unaltered to show the comparison between itself and the HTML edited field.

Note: You can utilize numerous formatting, such as (Assuming the Field value is 1.234):

· ${FIELD_o?string("0")} <– yields 1

· ${FIELD_o?string("0.#")} <– yields 1.2

· ${FIELD_o?string("0.##")} <– yields 1.23

· ${FIELD_o?string("0.###")} <– yields 1.234

· ${FIELD_o?string("0.####")} <– yields 1.234

You can even use this same method for Rounding purposes:

· If Field = 1.2, then ${FIELD.string("0")} yields 1.

· If Field = 1.8, then ${FIELD.string("0")} yields 2.

· If Field = 1.5, then ${FIELD.string("0")} yields 2 (Rounding always goes to nearest Even Number).

· If Field = 2.5, then ${FIELD.string("0")} yields 2 (Rounding always goes to nearest Even Number).

 

Created: February 29, 2008 | Modified: September 3, 2013

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

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

See all tags »

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