0 Replies Latest reply: Feb 15, 2016 9:20 AM by Kirsten Zawierucha RSS

    Expression does not show sum of rows

    Kirsten Zawierucha

      Dear community,

       

      I have created a small complex expression which does not show the sum of rows.

      How can I solve this problem?

       

      This is the expression:

      (
        Sum(
        Aggr(Sum({$<gYear={$(=Max(gYear))}>}ArticleAmount),Article,ArticleGroup,Depart,Group,TPBrn)
        /
        Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear))}>} DP_DPax),TPBrn)
        )
        -
        Sum(
        Aggr(Sum({$<gYear={$(=Max(gYear)-1)}>}ArticleAmount),Article,ArticleGroup,Depart,Group,TPBrn)
        /
        Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear)-1)}>} DP_DPax),TPBrn)
        )
      
      
      )
      * Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear))}>} DP_DPax),TPBrn)
      

       

      SumOfTotalRow.JPG

       

      Thanks in advance

      Kirsten