2 Replies Latest reply: Jul 12, 2016 3:30 PM by Bella Mae RSS

    Need help with an Expression.

    Yash Gandhi

      Hi,

      My data contains an OrderEndDate, OrderStartDate, OrderNumber.

       

      I calculated the number of days using the expression : [OrderEndDate]-[OrderStartDate] and named it as Date_difference.

       

      Now the next step I want is,

      For a given OrderEndDate,  get a list of OrderNumber on that date and also get the sum of Date_difference.

       

      I need help with this and which expression I should write.

       

      Thank you.