Calculating Area Under a Scatter Plot

[#1]

I have the following values in a Scatter Plot X and Y. I need to calculate in Qlikview the area of all the rectangles using the included formula. The result should be 0.91. Any ideas?

Score	Scatter Plot X	Scatter Plot Y	Area of Scatter Plot	Formula
1	1.00	1.00	0.03	(C2+C3)/2*(B2-B3)
2	0.97	1.00	0.02
3	0.95	1.00	0.05
4	0.90	1.00	0.06
5	0.84	1.00	0.07
6	0.77	1.00	0.10
7	0.66	0.99	0.08
8	0.58	0.99	0.08
9	0.50	0.98	0.09
10	0.41	0.97	0.06
11	0.34	0.95	0.04
12	0.31	0.94	0.04
13	0.26	0.92	0.06
14	0.19	0.86	0.07
15	0.11	0.72	0.04
16	0.05	0.53	0.01
17	0.02	0.36	0.00
18	0.01	0.23	0.00
19	0.00	0.11	0.00
20	0.00	0.06	0.00
21	0.00	0.00	0.00
Total	0.91

[#2 · Accepted solution]

Here you are attached.

[v_iyyappan]

Hi,

PFA,

Regards