Expression Aggregation

[#1]

Dear All

By default, the expression shows wrong result in Subheader Total.

But when I select Proposal Link Key than it shows Correct Amount in Subtotal Header.

The problem is with Loss on Settlement Amount. I am not able to aggregate it in Expression.

Kindly provide solution.....???

[sunny_talwar · Accepted solution]

Try this expression:

=Sum(Aggr(SUM([OD + POS FOR >180])+(IF(SUM(AGGR(NODISTINCT SUM([Total no. of Cases]),[Proposal Link Key]))>0,SUM([Loss On Settlement]),0)), Year, [Proposal Link Key]))

[#3]

Thank You Sir.

It is working Perfectly.