i'm trying to replicate this chart of my attached excel in QV... but without success.
What I'd like to do is to consider in the same table the value for open and closed invoices.
- Open invoices follow the due date cause they haven't got payment date so they will be in the same month-year of their due date.
- Closed invoices follow different variables... they have to be considered in the previous month-year of their payment date and then considered until the month-year of their due date.
Am I clear enough?
That's my data...
...and my final goal!
Cuold someone help me, please?
thank u in advance!!!
The classical solution for your need is buildind a Canonical Table please read this post Canonical Date
it should be self-explanatory.
Please come back if you don´t solve your isseu
thank you clever. I tried with a solution like something from that post, but it’s not the exact goal i‘m looking for cause as you can see from my excel calculation we have to create something like new data for the months where aren’t data from the payment date to the due date (i.e. for an invoice of 100$ payed in june and with a due date in March, what i want to obtain is 100 in may and 100 in Apri that doesn’t exist at the moment).
i don‘t Know if I added some info for the solution of my problem...
I'm sorry... ther was a mistake in the solution in excel...
this is the final table:
and I attach the fixed excel.