SUM weeks into Months

ChrisAHeathcote
Community Boss

SUM weeks into Months

Hi All, 

I am receiving a very unexpected error when trying to SUM Anaplan weeks into Anaplan Months.

The reason we are doing this is because the clients has an unusual calendar that we are not able to replicate in native settings.

Therefore, we created a mapping to map weeks into the month but I am receiving the following error;

 

ChrisHeathcote_0-1634293261491.png

I thought it could be because we are using a custom timeframe but I receive the same error even when I update my time systems line item to the custom time frame.

 

Very odd!

 

Hope there is an easy explanation. 

Chris
HeathcoteAndHerran.com
1 ACCEPTED SOLUTION

Accepted Solutions
MarkWarren
Expert

Hi I see what you're doing now, apologies, it needs the custom mapping. This is a bug, a know issue in fact.
I'm having a look at it. Maybe there is a way to do the same with a TIMESUM or a POST.
either that or fake timescales, which is not a great way to go...
Sorry, haven't got a great answer for you @ChrisAHeathcote 

View solution in original post

6 REPLIES 6
MarkWarren
Expert

Can you show the formulas involved?
I should think you would need to sum on a custom time list, then use a mapping to lookup that value into the real timescale. But fake weeks to real months...

ChrisAHeathcote
Community Boss

@MarkWarren 

Thanks for getting back to me. 

This is all in Anaplan time.

Source module;

ChrisHeathcote_0-1634295690990.png

ChrisHeathcote_1-1634295725625.png

Mapping Module;

ChrisHeathcote_2-1634295796493.png

Target Module;

ChrisHeathcote_3-1634295841082.png

In my head it should be a straightforward SUM from source to target via a time systems module.

But no!

Chris
HeathcoteAndHerran.com
MarkWarren
Expert

You should just directly reference the source, in fact you are already doing that for System Sales.
I must be missing something, what do you need in the target?

ChrisAHeathcote
Community Boss

@MarkWarren 

The clients calendar does not follow a standard roll up and can not be created from the standard calendar settings.

The mapping shows that some weeks fall into different months to the calendar settings therefore I am not able to simply reference the weekly module from the target. 

I need to map weeks into months using a custom mapping.

The solution I am using is to convert the real weeks used to make the calculation then convert to fake weeks before mapping into real months. 

This will work but is not a very elegant solution to what I think should be a straightforward SUM.

Do you know why SUM can not be used with TIME like this? Is there an alternative to the above option? Could I use TIMESUM even though the target is using a time dimension?

Chris
HeathcoteAndHerran.com
MarkWarren
Expert

Hi I see what you're doing now, apologies, it needs the custom mapping. This is a bug, a know issue in fact.
I'm having a look at it. Maybe there is a way to do the same with a TIMESUM or a POST.
either that or fake timescales, which is not a great way to go...
Sorry, haven't got a great answer for you @ChrisAHeathcote 

rob_marshall
Moderator

@ChrisAHeathcote 

 

I think there is an easy solution to this, now that you have given Mark the solution.  HA...

 

In your last picture, change the Time Scale format to Week, but keep the overall Time Scale for the module at Month.

 

Added some pictures for your viewing pleasure:

2021-10-15_10-33-42.png

 

2021-10-15_10-33-51.png

 

2021-10-15_10-34-03.png

 

2021-10-15_10-34-21.png

 

 

Let me know how it goes and if this gets you home.

 

Rob