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)
Thanks in advance
Kirsten