Skip to Content
0

Sum of absolute values in Context

Jul 05, 2017 at 06:12 PM

31

avatar image
Former Member

Dear all,

I have the following tables:

Table 1:

Country / Result

A

B

C

Table 2:

Country / Location / Good / Price / Variable cost / Fix cost

A / x / good 1 / 10 / 9 / 0

A / y / good 2 / 10 / 8 / 3

A / z / good 3 / 25 / 20 / 7

C / z / good 4 / 15 / 10 / 2

A / w / good 4 / 12 / 10 / 0

I would like to calculate the sum of abs(price - variable cost - fix cost) and obtain the following Result for the country A: 6. However I always obtain 0.

I tried the fomula sum(abs(price- variable cost - fix cost) in (location; good; country)) but it doesn't work.

Any help would be highly appreciated. Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers