Sum issue

[#1]

Good day,

Boss for all workers = Jan

But Jan is also on some of the jobs. I want to split the 'Nr' between Jan and the rest.

The problem is, I need the total for Jan to be 1+1+1+1+1+1+1+1+1+1 = 10

and not

1+1+1+1+1+1+1+1+1+1  * 10  = 100

Is there any way to do that, I cant use Max as some of the 'Nr' s won't be 1

See attached

Please help

[ariel_klien]

Hi,

Go to Chart properties > Expressions Tab and in the

in the Jan expression put: IF([Boss]=[Worker],[Nr],0)

and in the Total mode select sum of rowas.

hope this will help you.

BR

Ariel

[CELAMBARASAN]

Try with this

Sum({<JobCode={"=[Boss]=[Worker]"}>} [Nr])