Hey Everyone,
lets say I have a table with 3 columns
Column A = ID (Type Key)
Column B = Time Start (Type Time)
Column C = Time Finish (Type Time)
Virtual Column D = Time Spent (Type Duration) Formula = [Time Finished] - [Time start]
Virtual Column E = Total Time Spent (Type Duration) Formula = ??
Iโm having trouble getting a formula together for Column E. Im looking to Sum all of Column D. Im thinking it should be Somthing like sum(Time Spent) or along those lines but everything I try along these lines does not seem to work.
Any help would be appreciated. This is a pain in my arse.
Thanks,
Solved! Go to Solution.
Have you tried SUM(MyTable[Time Spent])
(replacing MyTable
with the name of the table)?
Have you tried SUM(MyTable[Time Spent])
(replacing MyTable
with the name of the table)?
Nope :), Thanks again for pointing out the obvious
Works like a charm
User | Count |
---|---|
40 | |
29 | |
24 | |
24 | |
13 |