0 Replies Latest reply: Dec 28, 2012 5:29 AM by Thomas Ljungström RSS

    Treat non transactional data as transactional

      Hi all!

       

      Even though I mentioned that this is a bad idea the customer still wants this and now I'm kind of stuck.

       

      I'm loading a list of prospects and several action lists. Action lists has a date, month actually, so I can follow a timeline how many of the prospects has an action each period.

      This also makes it possible to calculate a total percentage of how many prospects has an action (not limited to any period).

       

      Now to the (bad) idea;

      Each quarter they want to refresh the, initial, prospect list and action lists still arrive. Now, in order to separate the prospect lists I need a date (right?) but that puts me in a corner with the action lists since the dates don't match.

       

      I told them that percentage wont be comparable since prospects fall in, and out, of the list(s), but they still want this...

       

      So, how do I associate the prospect list(s) with the action list(s) and obtaining the date association?

       

      Happy New Year

      Thomas