Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try
=num(Sum({1< DateTest={'>=$(=MonthStart(Date(Date#('2014-06-30', 'DD/MM/YYYY'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'DD/MM/YYYY'),'DD-MM-YYYY'))'}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')
but it doesn't return any values , how to correct it ?
See if this helps:
=num(Sum({1< DateTest={'>=$(=MonthStart(Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY'))'}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')
See if this helps:
=num(Sum({1< DateTest={'>=$(=MonthStart(Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY'))'}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')
Did the above suggestion work? If not try this:
=Num(Sum({1< DateTest={">=$(=MonthStart(Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY')))<=$(=Date(Date#('2014-06-30', 'YYYY-MM-DD'),'DD-MM-YYYY'))"}>}[Prix de vente TTC] ),'# ##0 ;-# ##0 ')