2 data field results match, and return result from a 3rd data field (part 2)

[Yintak]

Hi

As the subject title suggests, I have a question below:

Country To	Country From	Sales Person	Turnover
France	France	Hugo	EUR 500
France	Germany	Julian	EUR 600
Germany	Germany	Marco	EUR 2,500
Italy	UK	Michael	EUR 4,500

Will we be able to construct an expression like this:

if([Country To] = [Country From], [Sales Person])

sum(if([Country To] = [Country From], [Turnover]))

Thank you!

[Yintak]

Hi

As the subject title suggests, I have a question below:

Country To	Country From	Sales Person	Turnover
France	France	Hugo	EUR 500
France	Germany	Julian	EUR 600
Germany	Germany	Marco	EUR 2,500
Italy	UK	Michael	EUR 4,500

Will we be able to construct an expression like this:

if([Country To] = [Country From], [Sales Person])

sum(if([Country To] = [Country From], [Turnover]))

Thank you!

[saminea_ANZ]

if([Country To] = [Country From], [Sales Person]) -- First condition will work

sum(if([Country To] = [Country From], [Turnover])) - Synthetically It is correct. But, Since in the data set value point consider as String. So, You can't aggregate like Sum never evaluate.

[Yintak]

So if we first transform the data field to a numerical value, i am assuming that the sum function will then work.

Thanks!