Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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