Notifications
Announcements
No record found.
I am trying to generate a P&L report that allows it to show an Inception to-date column. I work with contracts that where the Period of Performance crosses multiple fiscal years. How would I best format the Financial Dimensions Column Specifically as it pertains to the Fiscal Year,Period and periods covered cells. Can it be done in one column?
I would like to know this as well please if there is a solution
The best way would be to have one column that covered the prior year and another column for this year. You could then make them non-printing and add them together.
You could try using BASE : BASE-#. You'd replace the # with the number of periods you wanted to go back. If I did BASE : BASE-13, I'd get everything from the last 13 periods. If the base period in the report is 9, this would include everything from period 9 and back 13 periods (period 9 this year to period 8 last year). I have seen some problems with this, especially if the prior year is closed or the periods are marked as closed.
Thanks for sharing useful information with us.. It really helpful to MyAARPMedicare me..I always prefer to read the quality content and this thing I found in you post. thanks for sharing with us..
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 503 Most Valuable Professional
André Arnaud de Cal... 434 Super User 2025 Season 2
BillurSamdancioglu 278 Most Valuable Professional
