aggr group by dimension for Ratio

[#1]

I need to calculate the ratio of hours each employee spends on a job.  when I use the aggr function it seems to place the total in a random row,

What am I doing wrong here?

I've attached a sample app

[MK_QSL · Accepted solution]

Change your 2nd expression as

SUM(TOTAL <Job> Hours)