2 Replies Latest reply: Jul 16, 2014 6:46 AM by Mina Patel RSS

    How can I summate sales where the requested date is less than or equal to today

    Mina Patel



      I'm trying to calculate the number of items sold where the requested date of the order is less than or equal to today.

      I have use set analysis initially and used a flag to say of the order is in the current period mark it as 'Y' but its not working.

      ie the leading months are not being included.

      this is my set analysis expression:-



      Sum({$<OELRDCurrentPeriodFlag = {'Y'},OE_Order_Lines_All.OPEN_FLAG={'Y'},OE_Order_Headers_All.INVOICE_TO_ORG_ID-={1020}>} OE_Order_Lines_All.ORDERED_QUANTITY)


      Sorry if I haven't given all the information as I'm a bit new to all this...trying to get the hang of things.