Maptitude - http://research.umbc.edu/~roswell/maptitude.html
Colleagues,
Peter Van Demark from Caliper kindly offered this solution, along with
permission to post it here.
This code accomplishes two goals in Maptitude for the Web:
- To include only values greater than 0 in the pop-up table
- To concatenate two fields, while preserving comma and percent
formats. I get something like this below:
County: Harford
MCO_Org_A: 238 (2.3%)
MCO_Org_B: 2,114 (20.2%)
MCO_Org_C: 1,831 (17.5%)
MCO_Org_D: 985 (9.4%)
------- notes from Peter at Caliper -----------
Here is a sneaky workaround: use formula fields for each MCO, with an
if...then...else clause that leaves it null if there is no count, and puts
the percent in parentheses if there is a count. Null fields are not
included in the info table! Use only the CO_name and Total fields plus
these formula fields, with the following expression for each:
if [count] = 0 then null else Format([count], ",*0") + " (" +
Format([percent], "*0.0") + "%)"
where [count] and [percent] are the appropriate fields for an MCO.
The percent fields themselves can be formula fields, so they automatically
recalculate if the total or counts change. This should give you what you
want with no ASP programming, just dataview designing.
You might want to study Format(): it can have text before the format
characters by using < and after by using >; e.g., add the "%)" right into
the format:
Format([percent], "*0.0>%)")
You can do percents on the fly with % in the format:
Format([count]/Total, "*0.0%") + ")"
Have fun!
Peter
----------------------------------------------------------------
Peter Van Demark
Manager of Customer Services Phone: 617-527-4700
Caliper Corporation Fax: 617-527-5113
1172 Beacon Street E-mail: [EMAIL PROTECTED]
Newton MA 02461-9926 Web site: http://www.caliper.com
_________________________________________________________
Marjorie Roswell, Spatial Analyst
UMBC Center for Health Program Development and Management
1000 Hilltop Circle Fx: (410)455-6850
Baltimore, MD 21250 E: [EMAIL PROTECTED]
Ph: (410)455-6802 http://umbc.edu/~roswell/mipage.html
_________________________________________________________
______________________________________________________________________
To unsubscribe, write to [EMAIL PROTECTED]
Make your business more productive! Instantly automate routine
business tasks like payroll, time cards, expense reports, invoices,
purchase orders, business forms and more - for free! Try
Freeworks.com today at
http://www.bcentral.com/listbot/Freeworks
