set analysis 1-$

[Anonymous]

Hi to all,

aggr ( sum ( { 1-$ <Dataven={">=$(=timestamp(div1)) <=$(=timestamp(dfv1))"}>} QtaTot ) , Id_Art )

formula considerate 1  ( all database) and not 1-$

any idea?

Thank

[Miguel_Angel_Baeyens]

Hi,

I've checked your document and it's working fine. Total possible sum of q is 100, for the month of February, total sum of q is 20, and 1-$ equals to 80. What results do you expect here?

Regards,

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Attached is the checked application

[Anonymous]

Ciao,

i select month 4 and  sum  of q is 40 and is correct

if i select from calendr from 01/01/2011 to 31/01/2011   sum of q is 10 for each month i put in select

and this is wath i wanted ... the sum of q for month in the select  , and the sum of q in different date (div1 and dfv1)

and this work with

=aggr   ( sum ( { 1 <Dataven={">=$(=timestamp(div1)) <=$(=timestamp(dfv1))"}>}  q ) , a )

and not with 1-$ and don' understand why .. may be i missing something understanding in  set analysys???

[Miguel_Angel_Baeyens]

Hi,

You need to make coherent selections. If you select month 4 in field "m" (according to the file attached above), you need to select variables 1/4/2011 to 30/4/2011, otherwise, the selection done in the set modifier doesn't make sense with the current selection. Note that this is like using a lot of listboxes and try to select m = 4 and Dataven = 1/2/2011, you cannot, you select either one or the other, not both, because they are exclusive.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[Anonymous]

hi Miguel , yes u are right .. now i have understand difference between 1 and 1-$ in the set analysys. Thank you very very much for your help.