Split data for specific cells only

[#1]

Hello,

I have the following data:

Title	DwnID	Type	Downloads
Title1	1	same	20
Title2	1	same	0
Title3	2	same	40
Title4	2	same	0
Title5	3	dif	60
Title6	4	dif	80

and I want to split the Downloads for titles which have the same DwnID:

Title	DwnID	Type	Downloads
Title1	1	same	10
Title2	1	same	10
Title3	2	same	20
Title4	2	same	20
Title5	3	dif	60
Title6	4	dif	80

If I use Sum({<Type={'same'}>} Downloads/2) I get the right values for Titles which already have a Downloads value but for the rest the value stays '0'.

Any suggestions?

Kind Regards,

Ivelin

[#2]

I couldn't make the Join Load work with the applymap on and it looks like that's the very cause of the problem. If I remove it then each pair of Same Titles get assigned the full value and I can simply divide those by 2: If(Type='same', Sum(Downloads)/2, Sum(Downloads)). Removing applymap however, creates synthetic tables when I connect other data from other sources.