No way to get last month of quarter in one line item

No way to get last month of quarter in one line item

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.

 

The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.
1 Comment
Previous Contributor
 
Status changed to: Considered for Future Roadmap