topic Re: Get a count of value selected in a filter pane in App Development

Get a count of value selected in a filter pane

John117 — Mon, 04 Sep 2023 14:47:49 GMT

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

Re: Get a count of value selected in a filter pane

Zapparoli — Mon, 04 Sep 2023 15:05:32 GMT

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

Re: Get a count of value selected in a filter pane

John117 — Wed, 06 Sep 2023 09:33:29 GMT

Hi @Zapparoli

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

Cheers