Explore our best practices, forums, and more for all areas of the Anaplan platform.
Improve your knowledge of Anaplan with in-person and virtual training options.
Join the ranks of top model builders with our elite recognition program.
See what's new and exciting with Anaplan and our Community.
Suggest and vote on ideas to improve your Anaplan experience.
As an example, if the first month of the Fiscal Year is Mar 15, I want "May 15" returned because that's the last month of the quarter.
This is my formula (on a line item formatted as Month and no Timescale):FINDITEM(Time, NAME(PERIOD(END(PARENT(TIME.'Apr 15')))))
However, this returns 'Apr 15' due to this in Anapedia:https://community.anaplan.com/anapedia/calculation-functions/parent?inheritRedirect=true"If used with time period, the time period returned is determined by the time period granularity of the result."
"PARENT(TIME.'Apr 15') would need to find the relevant Quarter for this to work, but because of this constraint, it doesn't work.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.