Set Analysis showing total wrong

[Sahal]

i have a chart that looks like this.

How do i sum() employment rate where time <> 0?

The user "Emelie Larsson" i don´t get in the chart below but her employment rate is still in the total.

here is my set analysis for employment rate.

  even if the time field shows 0,00 and not 0 i have tried the same but that did not work

[maxgro · Accepted solution]

try

sum({$ <Name={"=sum(Time)>0"}>} [Employment Rate])

[perumal_41]

Hi

try

sum({$ <Name={"=sum({<WorkedFlag=[1]>}Time)>0"},[Employment Rate] -= ['10000']>} [Employment Rate])/100