2 Replies Latest reply: Jun 26, 2014 8:31 AM by Haidar Assaf RSS

    sales division in monthly sales regarding the run-time

      Hi,

      I am a beginner and need your help.

       

      I have a sales Value like 5000 (Project price) in Jan. 2014 but I need to build a table with monthly sales regarding the run-time of the project as 5 Month. This means: the customer pays 1000 every month. The same must be defined for a lot of projects.

       

      Example:

       

      My Table is:

       

      Project     begin               price     project run-time (in Month)

      A             01.02.2014       5000     5

      B             01.03.2014       2000     2

      C             01.04.2014       3000     3

       

      My result must be look like:

      -------------------------------------------------------------------------------------------------

                     Jan     Feb      Mrz      Apr       Mai       Jun     Jul     Aug

      Result:     0        1000    2000     3000     2000     2000    

      -------------------------------------------------------------------------------------------------

      Result explanation:

       

                     Jan     Feb      Mrz      Apr       Mai       Jun     Jul     Aug

      Project

      A               0        1000    1000     1000     1000     1000    

      B               0        0         1000     1000      0           0    

      C               0        0         0          1000     1000     1000    

       

      I hope, somebody can help me.

      Regards

      HA