Number of Dates selected

jerryr125 — Wed, 12 Jun 2019 11:48:59 GMT

Hi - I have a filter that selects the date (field: DATE).

I am using this formula to display the dates selected.

GetFieldSelections(DATE)

What if I want to count the number of DATES selected ?

I tried this :

COUNT(GetFieldSelections(DATE)) and it returns a 1 when I select 5 dates.

thoughts ? Jerry

Re: Number of Dates selected

JordyWegman — Wed, 12 Jun 2019 12:40:25 GMT

Hi,

Use this formula:

IF(Count(Distinct Date)=Count(Distinct {1<Date =>}Date),0,Count(Distinct Date))

As extra the formula looks if you made any selections. If you have selected none, it will return 0.

Jordy

Climber