Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
I am struggeling with a problem for a few month now. There are several posts that are kind of similuar but there is still something missing.
I have the current Stock value for the current month(e.g. june) in table stock.
I would like to create a calender or table for the next 36 month, the value for every month should be the current sum(stock value) like e.g.
Monthname(date); sum(stock value)
June/2021;100€
July/2021;100€
August/2021;100€
September/2021;100€
So on for next 36 month
In a Chart i would do this with total but i would like to create this in load Statement to create a canonical calender to join several calender dates like Orders to create a forecast.
This is just a part of my hole problem but find a solution for this part would help me a lot.
Thanks for every hint and sorry for this really bad discription of my situation.
Hello Sammy,
Thanks for Replying. As feared my question was not clear but i guess I solved it by my own. I try on monday to implement it. The solution should look like this.
Stock:
Load
IterNo()
Item
Quantity
Monthname(AddMonth(today(0),IterNo()-1))
From somefile.xlsx
While IterNo() <= 36;
I Know there are a lot of syntax errors but the concept should work.
This was a really bad first question to join the community but thanks anyway.
Best regards
Will
try this
Monthname(date); sum(total stock value)
Hello Sammy,
Thanks for Replying. As feared my question was not clear but i guess I solved it by my own. I try on monday to implement it. The solution should look like this.
Stock:
Load
IterNo()
Item
Quantity
Monthname(AddMonth(today(0),IterNo()-1))
From somefile.xlsx
While IterNo() <= 36;
I Know there are a lot of syntax errors but the concept should work.
This was a really bad first question to join the community but thanks anyway.
Best regards
Will