Summing 2 different rows

[lmendez818]

Hello
I need to be able to perform the following calculations to this data:

1. If Project Type = FIFO and Project Type = KL Phase 1 then agregate the Net Volume for both of them
2.If Project Type = NON FIFO,KL,KL Phase then SUM Net Volume for (Non-FIFO+KL-KL Phase 1)


Project Status   Net Volume
FIFO                  858,250.7
KL                  286,604
KL Phase 1   32,840
Non-FIFO                 67,440.69



I have tried an IF and Case When formula and I keep Getting errors.
I have attached the excel spreadsheet but here is a screen shot of the data as well.

PLEASE HELP!
Lis

[Francis aka khayman]

are you using dimensional or relational source?

[lmendez818]

relational source.

[Lynn]

Hello
I need to be able to perform the following calculations to this data:

1. If Project Type = FIFO and Project Type = KL Phase 1 then agregate the Net Volume for both of them
2.If Project Type = NON FIFO,KL,KL Phase then SUM Net Volume for (Non-FIFO+KL-KL Phase 1)


Project Status   Net Volume
FIFO                  858,250.7
KL                  286,604
KL Phase 1   32,840
Non-FIFO                 67,440.69



I have tried an IF and Case When formula and I keep Getting errors.
I have attached the excel spreadsheet but here is a screen shot of the data as well.

PLEASE HELP!
Lis

Why not post up your expressions and the errors you are getting? It would help you get better advice more quickly.

For your first calculation:

Code Select Expand


case
  when [Project Status] in ('FIFO', 'KL Phase 1' )
        then [Net Volume]
  else 0
end



For your second calculation:

Code Select Expand


case
  when [Project Status] in ('Non-FIFO', 'KL', 'KL Phase 1' )
        then [Net Volume]
  else 0
end