This content has been marked as final. Show 4 replies
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!