Solved: SUM(SELECT Expression should work but doesnt. - Page 2

Craig_S · 03-04-2024 03:17 PM

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

scott192

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.

View solution in original post