Display data

[Anonymous]

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 ?

[sunny_talwar · Accepted solution]

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 ')

[sunny_talwar]

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 ')