Last xx days

[#1]

Hi all,

i have one easy question:-)

I have easy expression,where i need to know all sales for last xx days (today - xx days)

I tried this,but it didň´t work...thx a lot for an advice 🙂

sum({<Type={'Sale'},Date={'>Today()-30'}>}(Sale.Value))

[swuehl · Accepted solution]

Try

=sum({<Type = {Sale}, Date = {">$(=Date(Today()-30))"}>}Sale.Value)

assuming Date field is showing your default date format (otherwise add appr. format code to the date function).