Sum last week

Anonymous — Sun, 25 Nov 2018 07:44:34 GMT

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

Re: Sum last week

andrey_krylov — Sun, 25 Nov 2018 08:38:25 GMT

Try this

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