Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone, I would need some help to get the following sum:
Both Eur and Delivery are linked to the key Ship-to:
For a Ship-to, there is a unique Eur (bijective function).
But for a unique Ship-to, there are multiple of Delivery (surjective function).
Ex: Eur (1)*Delivery (1,1) + Eur (1)*Delivery (1,2) +...+Eur(1)*Delivery (1,n) + Eur (2)*Delivery (2,1)+Eur(2)*Delivery (2,2)+...+Eur(2)*Delivery (2,m).
Please find enclosed the excel source & qlikview formula.
Thank you in advance!
Br/Ben
May be this:
Sum(Aggr(Sum(M3)*Eur, [Ship-to], Country))
Well done, thank you Sunny.
In fact you might want to try this also:
Sum(M3*Eur)
Right! thank you again.