3.2.11.1 Create Planning Period Filters

Confused on which Line Item I'm building a formula for, I'm assuming both. Also this is the formula I used to so that the weeks in that month are selected as well when you select the month are as follows. Please advise.

MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter),

Kind of confused why would not want to use WEEKVALUE if I want to show my Weeks.

Thank you

Comments

Misbah

@neg177

That is because the source module i.e., SYS00 module is at Month level and not week level. If you wish to write WEEKVALUE in your formula the output will be zero

Shahenaz

Misbah

Your insights are always so resourceful. The line item where formula should be used is I believe Planning period filter weeks only as we are converting months to weeks.

I had same doubt that why should we use MONTHVALUE & not WEEKVALUE. Thank you @Misbah!

Misbah

@Shahenaz

When you are trying to pull the values from Top Level (eg., Month level) to Bottom level (eg., Week Level) there are two ways to do so

1. Use LOOKUP on Month formatted line item from SYS Weeks module

2. Use MONTHVALUE - Why this ? Because the source module from where you are trying to get the data is dimensioned by Months and not Weeks. So even if you write WEEKVALUE there is no data associated to Weeks in that module

Hope that helps

Misbah

Miz Logix

Shahenaz

Understood. So we follow format of source module and not target module. Thank you for all your help. Appreciate it.

ami17

Please confirm the below formulas please

Planning Period Filter : 'SYS00 Time Settings by Month'.Planning Period Filter

Planning Period Filter Weeks Only: MONTHVALUE('SYS00 Time Settings by Month'.Planning Period Filter)

dpong8898

So, at the end, after the formula is created, do we still need to make sure the Time Scale is adjusted, i.e. to change from Week to Month?

just to make sure the checkboxes are shown at the month level?

Quick Links

Recent release news

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…