Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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).
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).