Forum Stats

  • 3,784,353 Users
  • 2,254,928 Discussions
  • 7,880,790 Comments

Discussions

Suppression Question on Financial Reporting Studio

User_EYCHP
User_EYCHP Member Posts: 1 Green Ribbon

Hi,

I have requirement to suppress column based on prompt of accounting period. My report has two prompts 1) Year 2) Accounting Period . Our company fiscal year is from Jul - Jun

When I run the report provide year as 2022 and Accounting Period as Aug-21 then report should only displays Jul-21 , Aug-21 and Sep-21,Oct-21,Nov-21,etc remaining periods as Zero ( This should be YTD data)

For eg : I would like to suppress column Sep-2021 and remaining column when I enter accounting period prompt as Aug-21 even though Sep and Oct period have data in current fiscal year

Could you please help me to provide solution for this and let me know if anymore information required.

Thank you,

Janardhan

Tagged: