Dynamic Day Calculation

Hi,

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.

Thank you!

Hendrik

Accepted answers

VIGNESH.M

Hi @HendrikDeCuyper ,

Try this,

I hope this gives the result you are expecting.

~Vignesh M

daniel_ellis

A slightly different solution:

rob_marshall

@HendrikDeCuyper ,

I know I am late to the game here, but here is another way of doing it:

Formulas for the line items:

First Date: IF Days you can order Boolean THEN START() ELSE BLANK

Last Date: IF Days you can order Boolean THEN START() ELSE BLANK

Calculation: Last Date[SELECT: TIME.All Periods] - First Date[SELECT: TIME.All Periods] - 1

Calculation First: IF START() < First Date[SELECT: TIME.All Periods] OR START() > Last Date[SELECT: TIME.All Periods] THEN 0 ELSE IF Days you can order Boolean AND START() = First Date THEN Calculation ELSE PREVIOUS(Calculation First) - 1

Rob

All comments

prabhu

Hi @HendrikDeCuyper,

Can i assume, you are trying to calculate, number of days between the line item Days you can order - Which is set as True.

Eg: in your example Days you can order is set as true on 9 and 14th April 2019. -> 4 days is between 9 and 14th April.....?

Is that the result that you are expecting on 9th April....?

HendrikDeCuyper

Hi,

Yes, that should be the end result!

VIGNESH.M

Hi @HendrikDeCuyper ,

Try this,

I hope this gives the result you are expecting.

~Vignesh M

daniel_ellis

A slightly different solution:

HendrikDeCuyper

Hi,

Thank you both for the quick response!

Appreciate the help, works like a charm.

Kind regards,

Hendrik

rob_marshall

@HendrikDeCuyper ,

I know I am late to the game here, but here is another way of doing it:

Formulas for the line items:

First Date: IF Days you can order Boolean THEN START() ELSE BLANK

Last Date: IF Days you can order Boolean THEN START() ELSE BLANK

Calculation: Last Date[SELECT: TIME.All Periods] - First Date[SELECT: TIME.All Periods] - 1

Rob

HendrikDeCuyper

Hi Rob,

Thanks for taking a jab at this as well!

Seems perfect.

Have a good day!

Hendrik

HendrikDeCuyper

Hi Rob,

Just realized this approach wouldn't work I think as you assume there are only two dates to take into account.

However this can vary and will mainly be around two times every week, but might be 3 or even 0.

As you're using the SELECT: Time.All Periods it wouldn't allow for multiple ordering dates, unless I got that wrong.

No need to adjust but just wanted to share my thoughts!

Thanks again for helping.

Hendrik

rob_marshall

@HendrikDeCuyper ,

You are correct, I assumed it would only be two dates which is where the SELECT All Time Periods comes into play. If you have multiple, you are correct in that you would either have to alter this solution or go with a previous solution provided.

Rob

Quick Links

Can you help?

Unanswered questions

Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…