How to Prorate Weeks Across Months in Anaplan?

chaOS
chaOS
in Modeling

I need to create a monthly filter for a grid that uses TIMESUM in Anaplan. I'm struggling because some weeks span across two months. For example:

January (Expected):
Start week: Jan 1 (Sunday)
End week: Feb 3 (Sunday)
Current Value:
Start week: Jan 1 (Sunday)
End week: Jan 21 (Sunday)
How can I prorate the weeks in Anaplan?

Answers

  • rayllon
    rayllon

    Can you provide some more details on what you are trying to achieve? Screenshots would help, as well as context on time dimensions you are using. Thanks!

  • seymatas1
    seymatas1

    How you see the weeks and months depends on what you chose in the model calendar:

    image.png

  • seymatas1
    seymatas1
    Week Grouping.zip

    I demonstrated week groupings in the attached recording.

Categories