topic Re: sum up but only one time the dimension in App Development

sum up but only one time the dimension

peisenrot — Fri, 02 Jun 2023 14:33:45 GMT

hello,

I want to sum up all Values of the dimension MaxRound but the each Name should be only

so my sum should be: (4+3+3+2) and not (4+4+3+3+2+2). how can I add in the formular "Distinct Name"

Aggr(sum(MaxRound), distinct Name) is not working

Thanks for help

Pia

rwunderlich — Fri, 02 Jun 2023 14:41:28 GMT

How about

Sum(Aggr(Max(MaxRound), Name))

-Rob

Kushal_Chawda — Fri, 02 Jun 2023 14:43:33 GMT

=sum(aggr(sum(distinct MaxRound), Name))

BrunPierre — Fri, 02 Jun 2023 16:19:26 GMT

You can try this too.

=Sum(Aggr(Only(MaxRound), Name))

sidhiq91 — Fri, 02 Jun 2023 17:42:14 GMT

@peisenrot I tried something at the script level first. Please see the script below:

NoConcatenate
Table:
load * inline [
MaxRound, Name
4, Detlef
4, Detlef
3, Pia
3, Mike
2, Petra
2, Petra]
;

NoConcatenate
Table1:
Load *,
if(Name=Previous(Name) and MaxRound=Previous(MaxRound),'Duplicate','Not Duplicate') as Check
Resident Table;

Drop table Table;

Exit script;

In the front End: Sum({<Check={'Not Duplicate'}>}MaxRound)

Please like and accept it as a solution if this resolves your issue.