problem with set analysis

[#1]

Hi all ,

in my project I have some data organized in this way

Date1 A1 B1
Date2 A2 B2
.
.
Daten An Bn



The values An e Bn (both number), are calculated with those formulas (vStartDate and vEndDate are variables for the search interval) (colonna_data e Chiarezza are column in my QV db)

An = (avg({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) * 100/9 )
Bn =(count({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) )


I need to calculate this value:

(A1*B1)+(A2*B2)+....+(An*Bn)

If I write the formula

=(avg({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) * 100/9 )*(count({<colonna_data={">=$(vStartDate) <=$(vEndDate)"}>}(Chiarezza)) )

the result is
(A1+A2+..+An)*(B1+B2+..+Bn)
that is not what I want

Any help will be appreciated

Thanks in advance

Alessandro

[marcel_olmo]

Could you upload a little document with all these stuff? Otherwise could be hard where is exactly the problem.

Arrivederci!!