2 Replies Latest reply: Apr 12, 2012 9:06 AM by giobenoni RSS

    basic crosstable load and summation of colums

      Hi,

       

      I have a sample source table :

       

      Capture.JPG

      to explain the table on the first row:

      LF3 is a machine line, working for 140 minutes, which of 30 minutes were downtime (C1 to C5 are Downtime types)

       

      So you would like to make a Crosstable : CrossTable(DowntimeType, Downtime, 2)

       

      This would give :

       

      LineTotalDowntimeTypeDowntime
      LF3140C110
      LF3140C20
      LF3140C30
      LF3140C40
      LF3140C520
      DF1330...

       

      Now I would like to make calculations on it :

       

      LF3 = 140 - 30

      so I thought : =sum(Total) - sum(DownTime)

       

      but for LF3 I get 700 - 30 = 630

       

      I could do avg(Total) - sum(DownTime)

       

      But I'm afraid I won't get away with that when I have multiple LF3 value entries for different dates

       

      Can someone help me?

       

      Thank you