Excluded value in set analysis

[Anonymous]

Hi to all ,

I have this expression :

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

i want to calculate the sum of QtaTot excluded by the current selection but it NOT work

Where is my mistake?

Thank

[fosuzuki]

Try this:

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

[Anonymous]

Hi Fernando,

the sintax is correct , the problem is that take out all the value of database , is like

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

thank for your help