Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached example.
Hi gwassenaar,
thank you very mutch!!!!!!!!!!!!!!!