Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Only({1} If( Aggr(Rank(
(
sum({<TipoMovimiento={Venta}, Vendedor -={'DIAZ ACOSTA JANET DE LAS MERCEDES'}, Año={'$(varAñoAct)'}>}CantidadUnidades*PesoArticulo)
-
sum({<TipoMovimiento={Devolución},Vendedor -={'DIAZ ACOSTA JANET DE LAS MERCEDES'},Año={'$(varAñoAct)'}>}CantidadUnidades*PesoArticulo)
)
,
4, 3),Vendedor) = 1,Vendedor))
It´s hard to find your problem without knowing your data.
Would you mind share a sample of your data? Preparing examples for Upload - Reduction and Data Scrambling
Maybe you have to use single quotes ' ' for TipoMovimiento because is a string:
TipoMovimiento={'Venta'} and TipoMovimiento={'Devolución'}