I did something like this a few years ago. The details are hazy, but I
think by opening a browser and right-clicking on the mouse, you get the
opportunity to add fields. Use the "pick fields" option, and chose
"expression" from the list. This gives you the opportunity to define a
field as an expression, allowing you to build in "sum" or other
mathematical operators.
The trick was that the field is temporary, and is not written to the base
table. The solution was to save it in a workspace which then re-established
the field and executed the fourmula each time you opened it.
You would need to build an expression which progressively sums the values,
and sorry, I'm not sure about that . Maybe assigning each record an ID
number would provide an index so an expression could be built that says the
value will be x (record ID number) plus x-1 (the previous summed total).
Perhaps it requires a programming solution. Alternatively, it could easily
be done in Excel, and the MI table created from the Excel file.
Hasn't spreadsheet-type functionality in browsers been on the MI wish-list
for a while?
_________________________
Peter Walsh
Senior Environmental Planner
URS Australia Pty Ltd
Phone : (02) 8925 5500 Fax : (02) 8925 5555
This e-mail together with any attachments is confidential and may be the
subject of legal privilege. If you are not the intended recipient please
email us by return email and destroy this message. You are not permitted
to copy, disclose or use the content in any way. Thank you.
"Kjartan Greiff Selnes" To: "Mailingliste
Mapinfo" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> cc:
Sent by: Subject: MI-L
[EMAIL PROTECTED]
onsmag.com
12/21/00 10:49 PM
Please respond to "Kjartan
Greiff Selnes"
Hi again List.
Are there a function in MI witch Sum "on the fly"
Like this:
integer_colomn Sum
4 4
2 6
1 7
1 8
3 11
Regards
Kjartan Greiff Selnes
Bravida Geomatikk
Norway
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
