2 Replies Latest reply: Feb 26, 2013 4:20 AM by Bill Ringer Salalima RSS

    How to do advance expression just like in excel?

      Hi,

       

      I need help for my inventory cover analysis. Inorder to get the following:

       

      FLOOR COVER: (InventoryBeginning-CurrentForecast)/NextForecast

      INVENTORY BEGINNING: Previous InventoryBeginning + Previous Purchase Order - Previous Forecast

       

      Look at the table below:

       

      FORECAST

       

      MONTH YEARQTY
      Jan 2012100
      Feb 2012150
      Mar 2012130

       

       

      PURCHASE ORDER

       

      MONTH YEARQTY
      Jan 2012120
      Feb 2012180
      Mar 2012135

       

       

      AND BELOW SHOULD BE THE REPORT FORMAT


      Jan 2012Feb 2012Mar 2012
      Inventory Beginning300320350
      Forecast100150130
      Purchase Order120180135
      Floor Cover1.33%1.31%-

       

      Any help with will be more appreciated.

       

       

      Regards,

      Bill