Extract a row and sum the rest of rows

[pgalvezt2021]

Hello,

How can I extract 558520 ? What I want is sum all except 558520,

Can you help me with this please?

Thanks !

[pgalvezt2021 · Accepted solution]

Got it !

(Sum(Aggr(
Sum(Venta) -
If(Len(GetFieldSelections(Filter)), Sum({<Cliente={"=Filter=Cliente"}>}DISTINCT Venta)),Cliente,Filter)))
/
(Count(Cliente)-
If(Len(GetSelectedCount(Filter)), Count({<Cliente={"=Filter=Cliente"}>}DISTINCT Cliente)))