6 Replies Latest reply: Apr 9, 2014 9:58 AM by Dariusz Mielczarek RSS

    Associate AGGR functions ?

    Benoît GIRARD

      Dear all,

       

      I'm working with sales documents/ sales document lines and the delivery document/ delivery document lines

      A sales sales document could have several schedule lines .

       

      I need to count the number of Schedulines with the following rules

      ActualGoodsMovementDate <PlannedGoodsIssueDate

      & one delivery document per Scheduline Lines !! (we do not want to count sales lines deliver in several times)


      Aggr function.PNG.pngaggr(sum(

      The following formula is working, but how I can add the case count(DelvDoc)=1 ?

       

      aggr( 

            sum(

                   if( "ActualGoodsMovementDate" <= "PlannedGoodsIssueDate"  ,1, 0)

                   )

         ,SalesDocLine)


      thanks in advance for your help.

      Regards