Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
(
Sum(
Aggr(Sum({$<gYear={$(=Max(gYear))}>}ArticleAmount),Article,ArticleGroup,Depart,Group,TPBrn)
/
Aggr(NODISTINCT Sum({$<gYear={$(=Max(gYear))}>} DP_DPax),TPBrn)
)
-
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)
Thanks in advance
Kirsten