Aggr or Set Expression?

[Anonymous]

Computer_ID	Date_Used	Time_used(hours)	User_ID
1	10/10/2017	2	rEyp
1	10/10/2017	2	J83x
1	10/10/2017	6	DnkF
2	10/10/2017	2	3PKS
2	11/10/2017	4	MDLf
1	12/10/2017	4	gqMB

Assuming I have the table from above, I need the sum of the Time_used for each Computer_ID, by taking the maximum possible amount per day.
In the above-mentioned case, the output should be something like:

Computer_ID	Sum_Time_used
1	10(6+4)
2	6

The question is: Should I use the aggr function or make a set expression in a sum()? Also, can you give me an example of how should I use the said function in the given example?

[tresesco]

May be like:

=Sum(Aggr(Max(hours), Date))

[luismadriz · Accepted solution]

Hi, I think it should be like this:

=Sum(Aggr(Max([Time_used(hours)]), Computer_ID,Date_Used))

[Anonymous]

That's about it, thanks!