Forum Discussion
Multiple Dates within one data set calculation
Hi Team, I hope you can help, I have a table with 3 different sales items Assessing, Tendering and Works They each have 3 different payments dates within the one table I want to get the sum...
| Assessing Cost | Assessing Invoice Date | Tender Cost | Tender invoice data | Repair Cost | Repair Invoice Cost |
| 1 | 1/03/2021 | 4 | 23/06/2021 | 100 | 1/01/2021 |
| 2 | 2/03/2021 | 6 | 24/06/2021 | 200 | 2/01/2021 |
| 3 | 3/03/2021 | 5 | 25/06/2021 | 300 | 3/01/2021 |
| 4 | 4/03/2021 | 4 | 26/06/2021 | 400 | 4/01/2021 |
| 5 | 5/03/2021 | 6 | 27/06/2021 | 500 | 5/01/2021 |
| 6 | 6/03/2021 | 7 | 28/06/2021 | 6600 | 6/01/2021 |
| 7 | 7/03/2021 | 3 | 29/06/2021 | 233 | 7/01/2021 |
| 8 | 8/03/2021 | 4 | 30/06/2021 | 234 | 8/01/2021 |
I want to Reference an average cost of all 3 revenue streams but I can use one date type otherwise I lose the other 2 revenues.