Question

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

• 4 replies
• 72 views

Userlevel 3
• Freshman I
• 13 replies

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 3

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

Userlevel 7

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

Userlevel 3

Hi Steven,

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 5

@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)