cancel
Showing results for 
Search instead for 
Did you mean: 

Sum of absolute values in Context

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (0)