Calculate Gross Profit = Revenue - COGS

[ihorwitz]

I have recently been trying power pivot and using the calculate function:

My table is as follows:

Product Account Description FY2012 FY2013
Apples R10000 Revenue $100 $120
Pears C20000 COGS 50 60
etc...

I tried to create a measure as follows:
Gross Profit:= CALCULATE(SUM[FY2013],Account="R10000") - CALCULATE(SUM[FY2013],Account="C20000")

Any help really appreciated.

 

[Laurent C]

I have recently been trying power pivot and using the calculate function:

My table is as follows:

Product Account Description FY2012 FY2013
Apples R10000 Revenue $100 $120
Pears C20000 COGS 50 60
etc...

I tried to create a measure as follows:
Gross Profit:= CALCULATE(SUM[FY2013],Account="R10000") - CALCULATE(SUM[FY2013],Account="C20000")

Any help really appreciated.

Can you, maybe, formulate a question?

What problem do you encounter?