8 Replies Latest reply: Sep 20, 2013 4:15 AM by Johan Ohlsson RSS

    Help with IntervalMatch

      Hi,

      I need some help with a problem I had for a while to calculate how many cars we have on stock each month.

      I have a source-table that looks like this:

      Contract

      RegistrationDate

      SoldDate

      10001

      201201

      201203

      10002

      201202

      201205

      10003

      201204

      201204

      10004

      201203

       

      Each contract represents a car.  RegistrationDate is when we received the car and SoldDate is when we sold the car. If SoldDate is empty it means the car is still on stock.

       

      I’m trying to get a stock-table that looks like this where I flagged each month the car is on stock:

      Contract

      201201

      201202

      201203

      201204

      201205

      10001

      1

      1

      0

      0

      0

      10002

      0

      1

      1

      1

      0

      10003

      0

      0

      0

      0

      0

      10004

      0

      0

      1

      1

      1

       

      I tried the IntervalMatch and connect the table to a Calendar without results.

       

      Can someone please help me with this?