Forum Discussion
Ordrebook
Hi
I have a problem with ordrebook value
I work in a consulent company, and i want to se the orderbook over time.
so i can follow how much we have in each month in the next month.
The data i have is, the project startdate, enddate, budgetamount on each project, i already have an date tabel, but somehow i cant figure out 🙂
Hopefully someone can help
4 Replies
are you able to provide some sample data?
Hi,
Share some data (in a format that can be pasted in an MS Excel workbook) and also show the expected result.
I have the following -
"last reg" - last registration on the case
"project enddate"
"reg amount" - Whats registrated
"Rest budget" whats left of the budget
"month" - The period between last reg and end date. ( i already have a date table
So now i want divide "rest budget" on to the next month within the last reg and end date 🙂
Sorry for the slow answer - hope u can help me out 🙂Hi,
Your question is not clear. Share raw data in a format that can be pasted in an MS Excel file and show the expected result.
