0 Replies Latest reply: Oct 24, 2014 8:00 AM by sergio Peschiera RSS

    Greater than set analysis issue


      Hello,

       

      I have two tables, one containing the details of every machine which isn't working and the reported date of the status (as well as Country, Product Line, etc). I also have another table with the total amount of machines (installed base) per Region and Product Line at certain periods (I have a "from" and "to" date for each Region-Product Line combination). I'm linking both tables per Region-ProductLine. What I want to do is divide the amount of non-working machines in a certain month by the installed base in the period that month is located into. I've tried the following expression but it ain't working:

       

       

      sum   (   {  < IB.FromDate={"<=Calendardate"},  IB.ToDate ={">=Calendardate "}   >}   distinct IB)

       

       

      The tables I have look like the following:

      Table 1:

       

      Machine IDRegionProduct LineCalendardateLink
      1AmericaA

      03/08/2014

      AmericaA
      2EuropeB08/08/2014EuropeB
      3AmericaB15/08/2014AmericaB
      4AmericaB25/09/2014AmericaC

       

      Table 2:

      LinkIB.FromDateIB.ToDateIB
      AmericaA01/11/201301/09/201410
      AmericaB01/11/201301/09/20148
      EuropeA01/11/201301/09/20145
      EuropeB01/11/201301/09/20147

       

       

      So what I'd want is to get the following table for AUGUST:

       

      Region\Product LineAB
      America1/102/8
      Europe0/51/7

       

       

      Please help me solve this issue and get the right formula. Thanks a lot in advance