2010 subtract

[beng986]

hey,

i am realtivly new to powerpoints are strugling a little. i am using the 2010 version.

i have extracted the table and now looking to add the forumlas in.

two questions, as its a simple formula F3-F4, should i just use a standard =f3-f4, or is there a way of doing this in powerpivot.

thanks.

 

[scottsen]

Looks like you are trying to use A1 style referencing, which doesn't exist in Power Pivot... which, btw, is a great thing.

Depending on what you got going on, it probably something like...

Total Revenue := SUM(MyTable[Sales])
Total Cost := SUM(MyTable[Cost])
Total Profit := [Total Revenue] - [Total Cost]