Spreading rule

[flesh2011]

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;