6 Replies Latest reply: Jan 14, 2013 7:58 AM by Klaudia Jakubkova RSS

    How to create expression - availability

      Hi experts,

      I hope that you can advice me with my task. I need to caluculate availability of items on the stock.

      My input data are stock quantity and requested quantity per day.

       

      ItemnumberStockRequestDate20121214201301072013010820130110201301112013011420130115201301162013011720130118
      A2772 0000360007272
      B3843 00000212102184
      C140 00000000028
      D0 0001084814412168072
      E2160 0000024042012204
      F6 4140000162603183672
      G736 00000721242886052
      H0 00000000108150
      I348 37800009008412624

       

      I need to reach this output in pivot table:

      Itemnumberdelay2013011420130115201301162013011720130118
      A273627362736273626642664
      B384338223822384338223759
      C140140140140140112
      D-156-300-168-324-156-228
      E216021362160174021481956
      F-408-570-468-726-444-480
      G736664612448676684
      H0000-108-150
      I-30-120-30-114-156-54

       

      Can anybody help me to find right expression?

      Thanks in advance.