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

# 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

• ###### Re: sales division in monthly sales regarding the run-time

See attached example.

• ###### Re: sales division in monthly sales regarding the run-time

Hi gwassenaar,

thank you very mutch!!!!!!!!!!!!!!!