I would like to ensure that for each negotiation with an amount xxxxxxx (which perhaps covers the date e.g. 12/06/2022 to 14/10/2026) I could see the relevant revenue for each year (in this case 2022 , 2023, 2024, 2025, 2026). How can I do it? Actually I am looking to a general formula that could calculate the yearly competence starting by the 3 properties (Start of contract, End of contract, Amount) . I don't want to calculate them manually for each deal. E.g.if I have a 100,000 euro contract that starts in June 2022 and ends in December 2024, I will have 20,000 euros for 2022, 40,000 for 2023 and 40,000 for 2024. After having set the amount properties, I start the competence and end the competence , I want this for every year the contract lasts E.g.
... Afficher plus