Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You need to get a count(K) in there. something like:
sum(if(name = 'Jack', Salary*K/count(K) ,Salary))
/Michael
Hi
You can try this
If(Name='Jack',sum(Salary * K),sum(Salary))
Anders