Forum Discussion
NewbieJono
Post Partisan
Post PartisanTotals on a Daily Level
Hello, i want a result to look at each table on a daily level and apply a set of rules for each day, then give total result.
for example. Volume Table
| Date | Volume |
| 01/01/2023 | 10 |
| 02/01/2023 | 10 |
| 03/01/2023 | 10 |
| 04/01/2023 | 10 |
| 05/01/2023 | 10 |
| 06/01/2023 | 20 |
| 07/01/2023 | 20 |
| 08/01/2023 | 20 |
| 09/01/2023 | 20 |
| 10/01/2023 | 20 |
sample Rate table
| Date | Sample Rate |
| 01/01/2023 | 0.5 |
| 02/01/2023 | 0.5 |
| 03/01/2023 | 0.7 |
| 04/01/2023 | 0.7 |
| 05/01/2023 | 0.7 |
| 06/01/2023 | 0.7 |
| 07/01/2023 | 0.9 |
| 08/01/2023 | 0.9 |
| 09/01/2023 | 0.9 |
| 10/01/2023 | 0.9 |
Expexted Results
| Date | Volume | SampleRate | Total |
| 01/01/2023 | 10 | 0.5 | 5 |
| 02/01/2023 | 10 | 0.5 | 5 |
| 03/01/2023 | 10 | 0.7 | 7 |
| 04/01/2023 | 10 | 0.7 | 7 |
| 05/01/2023 | 10 | 0.7 | 7 |
| 06/01/2023 | 20 | 0.7 | 14 |
| 07/01/2023 | 20 | 0.9 | 18 |
| 08/01/2023 | 20 | 0.9 | 18 |
| 09/01/2023 | 20 | 0.9 | 18 |
| 10/01/2023 | 20 | 0.9 | 18 |
| 117 |
pls try yhis
1 Reply
- Ahmedx
Super User
pls try yhis