Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello i try to find a way to create Missing months in my table below
Month and year come from invoice date but as i have no invoice for example in februray, so i have no line.
I would like all month to appear for one year as i need to allocate fix amount on each month (250€ as below)
Is there any way through script to generate those missing month (2,3...) ? (i tried to left join a calendar with autogenerate date but not working)
Customer | Month | Turnover | Fix Amount to allocate on 12 months even if month does not appear (not invoiced) |
040003 | 1 | 8 605.56 € | 250 |
040003 | 4 | 21 472.48 € | 250 |
040003 | 5 | 6 426.90 € | 250 |
040003 | 6 | 19 796.40 € | 250 |
040003 | 7 | € -556.80 | 250 |
040003 | 10 | 13 568.70 € | 250 |
040003 | 12 | 9 677.98 € | 250 |
040003 | Total | 78 991.22 € | 1750 |
Try this:
LOAD RowNo() as Month,
Turnover,
250 as FixAmount
Autogenerate(12);