Log In
Register
Home
August 17, 2019
Offline
Hi All,
I would like to generate new rows based on a number in the row and then transform the number into the month.
I am trying to create a budget plan for the next year, where some invoices comes only one a year and some of them each month. I have a column [frequency] that represents how often the invoice come. I was able to insert rows, but then I was lost how to transfom a number into a date e.g. 1.4.2020
The file with a sample and a result in enclosed.
Thanks Pavel
July 16, 2010
Offline
Hi Pavel,
Can you try uploading the file again, it's not attached.
Thanks,
Mynda
August 17, 2019
Offline
Hi Mynda,
It is there now.
Pavel
July 16, 2010
Offline
Hi Pavel,
Thanks for uploading the file. I have a few questions.
1. Is the 'result' sheet the result you managed to get, or the result you're trying to get? If it's the result you're trying to get, then can you please provide a mock up of the result you're wanting?
2. Where is your query? It looks like the table on the 'result' sheet comes from a query, so I'm wondering where it is so I can see where you're up to.
3. Will there only ever be 3 frequencies; 1, 4 or 12? or could there be others?
Mynda
August 17, 2019
Offline
Hi Mynda,
I enclosed a new files. I hope it better describes the puzzle.
Input file/table represents the manual input, that is supposed to be used as a source for the query.
Result tab represents what I want to achieve.
Then green tabs are represents my current solution. I use parameter and calendar tab to create myResult tab, however I dont know how to reclect the frequency in to the myResult. Invoice that is paid once a year has 12 rows.
To your questions
1) that is the result I am trying to get
2) input and result are manually created in this sample
3) I quess there might be 1,2,4, 6 and 12
Thanks, Pavel
July 16, 2010
Offline
Hi Pavel,
Thanks, much clearer now. See solution attached in query called 'input' on sheet called 'Solution' .
Mynda
August 17, 2019
Offline
Hi Mynda,
Thanks for the solution with list function using a parameter. I did a little clumsy adjustment, so that the quaterly invoices are expected to come in respective quarters, file is in the attachment.
Br, Pavel
