Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Assuming I have the following table:
Activity_ID | Date | ActivityType_ID | Time Period | Percentage |
---|---|---|---|---|
1 | 02-04-2018 | 6 | 10-14 | 0.5 |
2 | 02-04-2018 | 6 | 10-14 | 0.5 |
3 | 02-04-2018 | 9 | 14-16 | 0.25 |
4 | 03-04-2018 | 6 | 10-14 | 0.5 |
5 | 03-04-2018 | 11 | 14-18 | 0.5 |
6 | 04-04-2018 | 6 | 10-14 | 0.5 |
7 | 04-04-2018 | 6 | 10-14 | 0.5 |
8 | 04-04-2018 | 6 | 10-14 | 0.5 |
9 | 04-04-2018 | 6 | 10-14 | 0.5 |
10 | 04-04-2018 | 6 | 10-14 | 0.5 |
11 | 04-04-2018 | 6 | 14-18 | 0.5 |
12 | 04-04-2018 | 6 | 14-18 | 0.5 |
I need an Aggr formula that would produce a virtual table that's something like this:
Activity_ID | Date | ActivityType_ID | Time Period | Percentage |
---|---|---|---|---|
1 | 02-04-2018 | 6 | 10-14 | 0.5 |
3 | 02-04-2018 | 9 | 10-14 | 0.25 |
4 | 03-04-2018 | 6 | 10-14 | 0.5 |
5 | 03-04-2018 | 11 | 14-18 | 0.5 |
6 | 04-04-2018 | 6 | 10-14 | 0.5 |
11 | 04-04-2018 | 6 | 14-18 | 0.5 |
Further explanations:
The output table of the Aggr formula takes all activity_IDs that have different Time Periods and ActivityType_IDs and keeps the Dates correlated
How about this
Sum(Aggr(Percentage, Date, ActivityType_ID, Time Period))
What is the end goal that you are trying to achieve here?
Do a Sum on the Percentage field of the aggr table
How about this
Sum(Aggr(Percentage, Date, ActivityType_ID, Time Period))
That's it! Thank you!