Skip to Content

Calculate sum of months from Split week Planning book


I am facing an exceptional while trying to calculate the total percentage for months from Split week Planning book.


The logic to which I configure is to capture monthly totals in an Auxiliary key figure. To which I can use for Total & Percentage calculations/Validations.

Logic able to capture the change in month and do the new month’s sum using standard Functions of APO macro. (active adjusting periods adoption).

The Issue: The Sum function is not able to adjust periods when in case the Split week period is starting on a week end or with 4 periods.

Expected logic to be change:

Change the sum function to be intelligent to capture Month Start & Month end and calculate the total of the month.(need syntax to do it, as my syntax are all going wrong)

Appreciate if you can come up with suggestions & syntax respecting APO Macro function limitations.

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2017 at 07:52 AM

    Hi Sundeep,

    SUM function will take the periods the way they are created, so if there are only weekly buckets it won't split automatically in the week which is shared between the months.

    You need to create the periods in such a way that start and end of month is incorporated. This can be done using Fiscal year variant and thus creating the technical storage buckets as per your requirement.

    Hope this helps.

    Thanks & Regards,


    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 07, 2017 at 04:32 PM

    Fixit it with exception catch:

    Validating SUM function with FY-periods(FY Period start & end dates against Month). Quite complex but works for me.


    Add comment
    10|10000 characters needed characters exceeded