Dynamic Day Calculation
We're struggling with a conceptually easy topic which is surprisingly difficult to model build in Anaplan.
For a dynamic ordering calendar, so the days when you can order can be adjusted and are not fixed, we're looking to define the amount of days in between two ordering days.
Technically I'm stuck at the point where you have to get the pull back the amount of days to the 'ordering day'.
1. Days you can order = IF Days you can order Boolean = TRUE THEN 1 ELSE 0
2. Calculation Line = IF Days you can order = 0 THEN 1 ELSE 0
3. Days until next ordering day = CUMULATE(Calculation Line, Days you can order Boolean)
Now an extra line item should be built which pulls forward the 4 on 13 Apr 19 and puts it on 9 Apr 19.
Would be of tremendous value if someone could help to configure the line item formula.