4 Replies Latest reply: Jul 9, 2014 10:39 PM by Satyadev Jaiswal RSS

    expression combination

      Hey All

       

      Need to make a combination expression :

       

      Following expression is working

       

      =count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)

       

      Date               UNLOAD_TO_DIRECTIVE               EDI

      13/01/2014     EDI                                                EDI

      13/01/2014     KLBIKK                                          KLBIKK

      14/01/2014     BLE014                                          BLE014 

      14/01/2014     EDI + 20                                         EDI + 20

       

      Need the following overview - total of all directive and total of all EDI*

       

      Date               UNLOAD_TO_DIRECTIVE               EDI

      Total              4                                                   2

      13/01/2014     2                                                   1

      14/01/2014     2                                                   1

       

      Can some help me out plse

       

      Tks

      Rudi