Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi, I think it should be like this:
=Sum(Aggr(Max([Time_used(hours)]), Computer_ID,Date_Used))
May be like:
=Sum(Aggr(Max(hours), Date))
Hi, I think it should be like this:
=Sum(Aggr(Max([Time_used(hours)]), Computer_ID,Date_Used))
That's about it, thanks!