Split line in data loading

[CerilloS]

Hello, 

I have a table with accountnumbers and values. 

Below are the sales accounts which I can split to Area's with a total of 3100

Account	Area	Amount
50001	A	1250
50002	B	1350
50003	C	500
Total		3100

I also have a cost account, This is one single account not split into areas.

Account	Area	Amount
60000		550

Now I would like to split the costaccount depending on the ratio of sales per area 

Account	Area	Amount
60000	A	221,77
60000	B	239,52
60000	C	88,71
Total		550

How Do I get this done in the loading script?

Regards,

Cerillo

[chaorenzhu]

Is there any UID to link your sales account and cost account? Seems that you're splitting your cost account Amount according to the ratio of sales account Amount, but how do you know which one to refer to?

[CerilloS]

Hello Chaorenzhu,

Thanks for the reply. Indeed I want to split my costs as a ratio to my sales accounts. As reference I want't to split the cost based on the ratio of last years sales.  As my cost are not always made in the same period as the sales, I cannot use the same period as reference. Also not all months have the same pattern. As such using the ratio of last year will give me the best result. 

Thanks,

Cerillo