TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?

AlejandroGomez
Master Anaplanner/Community Boss

Re: TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?

thanks for your input @ChrisHeathcote,

 

Let me just point out that I tested this myself and I can ensure that the error message appears even though the Target and Source line items are correctly formatted.  As per the Anapedia documentation, this calculation should work with the settings from @litterbarbie ...

Misbah
Moderator

Re: TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?

@AlejandroGomez 

 

Well my hypothesis says that we can't use aggregation functions (SUM, MovingSUM, TIMESUM etc) on Time Period Formatted Line items if  that particular line item has Time dimension in its module.

Ingilavicus
Certified Master Anaplanner

Re: TIMESUM cant aggregate(e.g. MAX) time period on time period dimension?

Hi All,

 

I had a similar issue a while back. I contacted support thinking that this is a bug and we came to the conclusion, that it might be linked to the MAX function, where a number or a data format is required. At least that was consistent when I was trying to get a result out of TIMESUM using MAX. 

 

Ingilavicus_0-1612508938268.png

 

But this of course doesn't match what @rob_marshall said that in his testing it indeed is a bug. 

 

Would be quite interested what is the real reason. 

 

Andris