2 Replies Latest reply: Nov 29, 2016 4:27 AM by Виталий Чуприна RSS

    Combine Set expression

    Виталий Чуприна

      Hi All,

       

      I have following expression:

       

      $(vTotalOrder)

       

      sum(OrderLA)

      ______________________

      $(vShipped)

       

      sum(
      {$ <
      [Order Status]*={'*1', '1*'},
      [Code]*=-{'To'}>
      } Order
      DA )

      ______________________

      $(vCalcOrder)

       

      =$( vTotalOrder)-$( vShipped)

      ______________________

       

      $(vOrderInBack)

       

      sum(
      {$ <
      [Order Status]={'>=01<=12'},
      [Code]=-{‘To’},
      [$(=DateF) Date]*={'<$(vCalcDate)'}
      >}
      (OrderL
      A-OrderIA))

       

      I need to know how many OrderInBack in vCalcOrder.

       

      How can I combine those set expressions?