One-to-many duplication

[#1]

Hi everybody!

I have expression sum(if(name = 'Jack', Salary*K, Salary)).
If name isnt Jack but for ex. John (as below), result is not 5000 as I need, but
10000 (5000 duplicates). Can it be solved somehow?

thanx

[#2]

You need to get a count(K) in there. something like:

sum(if(name = 'Jack', Salary*K/count(K) ,Salary))

/Michael

[#3]

Hi

You can try this

If(Name='Jack',sum(Salary * K),sum(Salary))

Anders