Sum last week

[Anonymous]

Hi

I have a pretty basic problem. 

Sum({<[Date]={">=WeekStart(today(1),-1)<Weekend(today(1),-1)"}>}Amount)

For some reason this expression keep on returning a 0. I have run through all the date formats, and as i can see they are all DD/MM/YYYY  

Can any of you see the problem? 

Best Regards Jesper 

[andrey_krylov]

Try this

Sum({<[Date]={">=$(=Date(WeekStart(today(1),-1)))<=$(=Date(Weekend(today(1),-1)))"}>}Amount)