By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
Acumatica Analytical Report Manager (Financial Report Writer)
1
Posts
1
Users
0
Reactions
384
Views
September 18, 2024 5:14 am
I'm building a report that displays three years of P&L data.
I created a column set for that but I would like to hide columns based on the @StartPeriod and @EndPeriod parameters.
So far I have come up with this formula (that's for the first column of the 36 periods report):
=iif(Report.FormatPeriod(@EndPeriod, -35) >= @StartPeriod AND Report.FormatPeriod(@EndPeriod, -35) <= @EndPeriod, true, false)
but it filters out just columns where month filter fits the criteria (ie. with parameters @StartPeriod: 05-2023, @EndPeriod: 09-2024 it shows 06-2022, 07-2022, 08-2022, 09-2022, 05-2023, 06-2023, 07-2023, 08-2023, 09-2023, 05-2024, 06-2024, 07-2024, 08-2024, 09-2024)
Any suggestions will how to adjust my Visible Formula will be beneficial.
/Mike