Spoiler (Highlight to read)I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?

Month to Date Format - Anaplan Community

Write END(Date) as formula. If there is a time as a dimension then just END() would do

Misbah

Write END(Date) as formula. If there is a time as a dimension then just END() would do

Misbah

You can use End() function to get end date of the month

Thanks

Thanks for the help.

How can I use the RANK function with composite hierarchies where parent items can't be concatenated?
I am working on a use case where I need to display the top 5 lines of a module as individual lines, while grouping all remaining lines under an "Others" category. The module is dimensioned by multiple composite hierarchy lists, along with Time and Version. To achieve this, I need to use the RANK function with the Ranking…
Integration Process Execution Access - Which Access Takes Precedence?
We have an Integration Process in Anaplan CloudWorks created by User X - No WSA (originally Full Access with top-level Selective Access, now changed to Planner Read Only with Selective Access unchanged) and scheduled by User Y - with WSA , who also created the Integration Flow. Internal (Full Access) is enabled within the…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…