Total expression not working

[pcservicios]

Hi.

I've a little problem calculating the total of a straight table.

The expression is 

=sum(aggr(Estancias/Trabajadores,Departamento))

But the Total row is not as expected.

I upload a example in .qvw file

The expected total is 200/33 = 6.06

Thaks for your help

[stevejoyce]

I can't access your qvw, but your calculation would be first dividing Estancias/Trabajadores for each Departamento, and then summing your percents.  I can't tell if you actully need aggr, but im guessing you want to do something like...

=sum(aggr(sum(Estancias)/sum(Trabajadores),Departamento))

[Taoufiq_Zarra · Accepted solution]

@pcservicios  or you can change your measure like

attached qvw file

[pcservicios]

Thanks Taoufiq for your help!

[pcservicios]

Thanks for your help, but this not work for me 😞