Hi.
I`m stuck in a rule and just need a little push.
I have 2 cubes:
1. for input on customer level.
and another for input on customer group level.
When i`m done calculating the discount pr kg, i want to spread the total customer group level discount on each child members of each group (leaf level)
something like this.
group 1= 1£ pr kg
group 1
customer 1 discount 2£ + group discount 1£ = 3£
customer 2 discount 4£ + group discount 1£ = 5£
customer 3 discount 0£ + group discount 1£ = 1£
group 2
Am i thinking too difficult?
Must be an easy thing to do?
['total discount']=IF ...........................,db group discont + customer discount,customer discount);
Thanks in advance.
UPDATE:
got it to work :);
['Sum rabatter']=N:If(ELPAR('kunde hieraki',!Kunde hierarki,1)@=Attrs('Kunde hieraki',!kund hieraki,'KundGrupp'),DB('Avtaleregister kunde',!Avtaler,Attrs('Kunde hieraki',!kunde hieraki,'KundGrupp'),'Rabatt pr kg'),Continue);c:0;