Modeling Ideas

Suggestions related to modeling

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:…
Convert time period to a date
Description of the enhancement required: As an extension or alternative to the DATE function
Additional week formats
Description of the enhancement: We would like to have a Week format that will combine the number of the weeks in period and the period associated with the week. For example, for week 50, we'd like to see Wk 2 - P13 FY14. I imagine this is a concern for retail companies as this is the way most retail companies look at…
Drilldown displays formulas without parenthesis, and cannot be copied back into line item
Description of the RFE: Users are copying and pasting formula from drilldown dialog, which isn't possible because parenthesis are removed. This is an RFE to retain the parenthesis, or at least provide that option. Use case: Drilldown formula is removing parenthesis. This is causing come issues for us working with a large…

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!

Discussion List