AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Analytica...
Visible formula for...
 
Notifications
Clear all

Questions Visible formula for multi-year report

 
Acumatica Analytical Report Manager (Financial Report Writer)
Last Post by Mike Collins 2 years ago
1 Posts
1 Users
0 Reactions
930 Views
RSS
Mike Collins
Posts: 16
 Mike Collins
Topic starter
September 18, 2024 5:14 am
(@mike_collins)
Eminent Member
Joined: 5 years ago

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


Forum Jump:
  Previous Topic
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 88 Online
  • 2,438 Members
Our newest member: Ralph Torres
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×