Skip to Content
avatar image
Former Member

Sum of absolute values in Context

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers