8 Replies Latest reply: Jan 23, 2013 11:34 AM by Claudio Degli Antoni RSS

    Problem with sum aggr without total amount

    Claudio Degli Antoni

      Hi All,

       

      I'm prabably a simple problem but i'm not able to find a good solution.

      1) The follow expression doesn't show the total

       

      IF (
      sum( {$ < DELIVERED ={'>0'} , UNDERSTOCK ={'0'} > }
      if(aggr (nodistinct sum(UNDERSTOCK),INVOICE) >0 ,VALUE_DLVR) )
      >65,
      VALUE_DLVR

      )

       

       

      2) There is another easy way to solve this expression

       

      Hire attached the example of qvd files

       

      Many Thanks

      Claudio