SUM(SELECT Expression should work but doesnt.

[Craig_S]

Hi All,

First time asking for help, so please forgive me if its silly one.

I've done my best to find the answers im after, but im at a loss.

Im trying to SUM the total hours worked for a particular job from my "Hours Log" Table and present them in my Job's Table. in my Job Table each row is a job and i would like to SUM only the hours for that particular Job.

The expression im using is 

SUM(SELECT(Hours Log[Hours],[Job]=[_THISROW].[Job Number]))

Its telling me its a working expression, however the resulting duration im given is 00:00:00

I'am at a loss, am i missing somthing simple? haha

[AleksiAlkio]

What is your column type in "Hours" column?

[scott192 · Accepted solution]

If you have an hours table that is related to your Jobs table, then on your Jobs table you should have a system created field called [Related Hours Logs] or something like that?

You can use SUM([Related Hours Logs][Hours]) in a virtual column to get the sum of all entered hours for each row in your jobs table.

[Craig_S]

Thats perfect Scott, does exactly what i need!

Legend!