Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 3 of 3

DivideByField doesn't work property with 0 value

This is a discussion on DivideByField doesn't work property with 0 value within the MapPoint Desktop Discussion forums, part of the Map Forums category; If I do a datamapping with my personal data and I choose to divide a field by another one (in ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    DivideByField doesn't work property with 0 value

    If I do a datamapping with my personal data and I choose to divide a field by another one (in one record this field is 0), the record with the DivideByField value equal to 0 isn' considered.
    Let me show you an example

    Amount2003 Amount2002
    100 2
    300 4
    500 0

    I want to calculate the Total amount of 2003 divided by Total Amount of 2002 per Region (in this case, I suppose I have only one region)

    I choose for the datamapping:
    field = Amount2003
    DivideByField = Amount2002
    Operation: sum

    The result is (100+300)/(2+4) instead of (100+300+500)/(2+4+0)

    Why?

  2. #2
    Mossoft is offline Member Yellow Belt
    Join Date
    Feb 2003
    Posts
    48
    Its the old "What shall I do with infinity?" problem.
    Try doing all the calculations external from MP (in XL for example), then you can replace all errors with meaningful values e.g. #DIV/0! --> 0 before import.
    You may need to import a couple of datasets (a summary and a detail)

    HTH

    M.

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    I think it's correct that MapPoint will return infinite from Value/0, but it's non correct that performs single operations (Value1/0, Value2/3) etc.
    It could only check if the sum of values (0 + 3 +4) is different from 0!

    In my previous example

    The result is (100+300+500)/(2+4+0), Mappoint could check if (2 + 4+ 0) is different from 0, why it checks 500/0 and then delete that information??

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Highlight property
    By Yazzy in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-08-2005, 02:38 PM
  2. Property MatchingMethod results (VBA)
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 11-05-2004, 10:47 AM
  3. Mappoint - TopScore property
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 03-26-2004, 09:41 AM
  4. Where are the saved property in mappoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 05-15-2003, 06:33 AM
  5. Altitude property
    By Labtek in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-02-2003, 09:28 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67