Getting double values since the rows have the same name but not value

[aidalj28]

Hello,

I have 3 excel tables which I joined in Data Manager. Something like this:

1. Table with old names and some data

OldName	Data
24hdla93	10
3dmafh7	20
nfjs93la3	30
d38ma39	40

2. Table is only to define new names, but sometimes 2 different oldnames should appear under ONE newname!

OldName	NewName
24hdla93	Apple
3dmafh7	Strawberry
nfjs93la3	Banana
d38ma39	Banana

3. Table is extra row of data which I want to show at the end

NewName	Value
Apple	3
Strawberry	6
Banana	2

The table I want to get is (Data is added, but Value should stay the same):

NewName	Data	Value
Apple	10	3
Strawberry	20	6
Banana	70	2

And I am getting this (Value for Banana is doubls, although I want to show only 2 for Banana, and not 4):

NewName	Data	Value
Apple	10	3
Strawberry	20	6
Banana	70	4

Can someone please help me?

[tresesco]

@aidalj28 

With your data structure by default it should give '2' against a Sum(Value) expression. However, if you are using kind of Sum(If(..., it could result in an output of '4'. In such cases where you have to put a condition you could use set analysis instead of if, like:

Sum({<NewName={'Banana'}>}Value)