Need to calculate days of a project - kind of complex

[WolfShade]

Hello, everyone,

I’m running CF server connecting to an Oracle db.

I have a table that keeps track of projects (past, present, future) and need a way to sum the days for each project, for each month, that have happened.

For example.

ID   -    Name                -   Start      -   Stop        - Employees
001      Project A            01-Oct-14     31-Dec-14             8
002      Project B            06-Feb-15     21-Feb-15             9
003      Project C            30-Oct-14     29-Nov-14             3
004      Project D            26-Dec-14     16-Apr-15            21

I’m trying to create an overview where the display will have the months of a Fiscal Year go across the page, indicating the number of employee days for each project that have elapsed. (NOT counting the current day)

Project      -   OCT - NOV - DEC - JAN - FEB - MAR - APR - MAY - JUN - JUL - AUG - SEP
A                248   24     0     0     0     0     0     0     0     0     0     0
B                  0    0     0     0     0     0     0     0     0     0     0     0
C                  6    9     0     0     0     0     0     0     0     0     0     0
D       etc..

I’m not wrapping my head around this, for some reason. Mental block. Any ideas?

V/r,

[DaveMaxwell]

You’ll want to use the PIVOT functionality if I understand your question correctly

Oracle Pivot examples