Hello all,
I have a series of tables that I need to join together before bringing in the costs.
I have some flexibility in the table designs, but not much.
the output of the attached is
PD | BS | VCA | PROJ_PH | SUM(COST) |
AG1 | APROVED | EXA1 | - | 10000 |
AG1 | APROVED | EXA2 | - | 10000 |
AG1 | APROVED | - | 1 | 10000 |
AG1 | APROVED | - | 2 | 10000 |
AG2 | pENDING | EXA1 | - | 18000 |
AG2 | pENDING | EXA2 | - | 18000 |
AG2 | pENDING | - | 1 | 18000 |
AG2 | pENDING | - | 2 | 18000 |
| | | | |
for some reason, the lines with proj_ph are put on their own lines.
If an "Exit Script" is added right before the interval match, the table looks like I want it, but the costs are not summed per the intervals they belong.
EXA1 should be with proj_ph 1
eXA2, proj_ph 2
any help is appreciated