This content has been marked as final. Show 3 replies
I have to calculate sum of sales, condition is I have to sum sales for last week only.I have date field called Date_D that has all the dates. I want to make my set expression dynamic ..How Can I do with Variables and with out variables.
one more query,
In this query, I need to calculate sum sales for yesterday date , but I can not use Today()-1 as on Moday, it will fetch Sundy Data and I dont have any data for sunday,
I tried this logic
but how to use in Set Expression or by using variables?
Thanks in Advance !!