on 07-05-2017 7:12 PM
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!
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.