Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 380
- Office Version
- 365
- Platform
- Windows
Good afternoon,
What I would like to achieve is the average marge of every month, but needs to be for the current year only and needs to change with the new year. The sheet below is a sample of the 80.000 plus records I have. Can this be done?
Thank you for your time.
Romano
What I would like to achieve is the average marge of every month, but needs to be for the current year only and needs to change with the new year. The sheet below is a sample of the 80.000 plus records I have. Can this be done?
Thank you for your time.
Romano
| Omzet Kolhler groep 2023 1.07.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AP | AQ | |||
| 2 | itemcode | Costprice | Netto price | Invoicedate | Marge | |||||||||
| 3 | 101000 | 1,17 | 1,65 | 06/01/2020 | -29,09% | |||||||||
| 4 | 101001 | 1,17 | 1,65 | 06/01/2020 | -29,09% | |||||||||
| 5 | 120033 | 5,026 | 5,93 | 06/01/2020 | -15,24% | |||||||||
| 6 | 120038 | 4,901 | 4,46 | 05/02/2020 | 9,89% | |||||||||
| 7 | 120051 | 5,403 | 5,48 | 06/02/2020 | -1,41% | |||||||||
| 8 | 120055 | 5,529 | 5,55 | 06/03/2020 | -0,38% | |||||||||
| 9 | 120060 | 5,529 | 5,12 | 30/03/2020 | 7,99% | |||||||||
| 10 | 134029 | 2,446 | 3,17 | 06/04/2020 | -38,46% | |||||||||
| 11 | 133036 | 2,127 | 3,65 | 06/06/2020 | -35,55% | |||||||||
| 12 | 137000 | 2,766 | 4,3 | 06/07/2020 | -22,83% | |||||||||
| 13 | 137003 | 2,865 | 4,72 | 06/09/2020 | -38,85% | |||||||||
| 14 | 125004 | 15,21 | 23,6 | 06/02/2023 | -41,73% | |||||||||
| 15 | 133030 | 2,184 | 2,83 | 01/02/2022 | -22,84% | |||||||||
| 16 | 123006 | 2,431 | 3,95 | 06/03/2023 | -35,67% | |||||||||
| 17 | 133034 | 2,018 | 3,3 | 01/06/2023 | -39,30% | |||||||||
| 18 | 125004 | -4,3715 | -6,525 | 06/02/2023 | -52,99% | |||||||||
| 19 | 133030 | -8,3044 | -12,503 | 06/02/2023 | -19,46% | |||||||||
| 20 | 123006 | -12,2373 | -18,481 | 06/03/2023 | -48,19% | |||||||||
| 21 | 133034 | -16,1702 | -24,459 | 01/06/2023 | -100,00% | |||||||||
| 22 | January | February | March | April | May | June | July | August | September | October | November | December | ||
Data | ||||||||||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| AJ3:AJ21 | AJ3 | =(Table_Query_from_100_2[@CostPriceStandard]-Table_Query_from_100_2[@[prijs_n]])/Table_Query_from_100_2[@[prijs_n]] |
