Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=aggr ( sum ( { 1 - $ <Dataven={">=$(=timestamp(div1)) <=$(=timestamp(dfv1))"}>} QtaTot ) , Id_Art )
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