Question

How to show an ARM column set based on the report parameter

  • 23 October 2023
  • 4 replies
  • 70 views

Userlevel 3
Badge

Hi All, 

I have created a column set that has a period from 01-2020 up to 12-2023 where I want to be able to run an Income Statement report based on the parameter that I set in the report parameters. So, I put a range 02-2020 to 08-2023 in the report parameter but the on the report output it shows all the columns available in the column set.

In my column set, I use the visible formula below. (note: the period changes per column)

=IIf((Left(@StartPeriod,2)<=1 And (Right(@StartPeriod,4)<='2020')) or (Left(@EndPeriod,2)>=1 And (Right(@EndPeriod,4)>='2020')),true, false)

Any help would be highly appreciated. 

Thank you very much. 

Regards, 
Anne Samson

 


4 replies

Userlevel 5
Badge

@ASamson21 - You can try the following:

=IIf(((CInt(Right(@StartPeriod,4)) > CInt(Right(@EndPeriod,4)))

    Or

   (CInt(Right(@StartPeriod,4)) = CInt(Right(@EndPeriod,4))

   And CInt(Left(@StartPeriod,2)) >= CInt(Left(@EndPeriod,2)))),

  true, false)

Userlevel 3
Badge

Hi Steven, 

 

Thank you for your response. 

I have tried to use the formula that you have shared. Unfortunately, it doesn’t work as expected. I have put a report parameter as follow:
Start Financial Period = 02-2020

End Financial Period = 04-2023

The report output shows nothing in the column.

 

Am I missing something here?

Thank you.
 

 

Userlevel 7
Badge

Hi @ASamson21 were you able to find a solution? Thank you!

Userlevel 3
Badge

Hi @Chris Hackett not yet. I am still finding a solution for this. 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved