3 Replies Latest reply: Jun 24, 2016 12:37 PM by Sunny Talwar RSS

    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.

    Siddharth Sharma

      Hi ,

       

      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

      date(if(WeekDay(today())='Mon',(today()-3),(today()-1))

      but how to use in Set Expression or by using variables?

       

      Thanks in Advance !!

      Sid