Get a count of value selected in a filter pane

[John117]

Hi All,

my requirement is to be able to use the number of values selected in a filter pane in a calculation in a table..

I have a filterpane which contains MonthNames - Jan 2023 - Dec 2023. This field is not included in the table in which I want to make my calculation.

Based on how many months the user selects I want to use the count in a calculation of demand. By default in my table the demand figure is annualised. If a user selects one month in the filter pane I want the demand figure to be 1\12th, if they select two months 2\12ths and so on.

I was hoping to be able to capture the count of selected periods in a variable and then use it in my calculation of demand. Something like this:

=Sum(Demand)/12 * vCountPeriods

Any suggestions would be appreciated..

Thanks

[Zapparoli · Accepted solution]

Hi @John117 

Maybe you can use the GetSelectedCount Function

Like this: 

GetSelectedCount(Period)

Then on your Formula:
(Sum(Demand)/12) * GetSelectedCount(Period)

Let me know if it helps.

-Zapparoli

[John117]

Hi @Zapparoli 

thanks, that worked. Could swear I tried the same previously without the same result..

Cheers