You’re offline. This is a read only version of the page.
Announcements
61
Hi
I have a textfield with the results of more data, with the text formula:
Sum(Filter('5366 - Acties (registratie)';'SOORT ACTIE'="VERKEER");'GECONTROLEERDE PERSONEN')
I want to add 2 datepickers (start and end) to filter by date.
How do i have to change the formula?
@Wagemans_Frank try the below pattern:
Standard way:
Share
Report
All responses (
Answers (
Sum(
Filter(
'5366 - Acties (registratie)';
'SOORT ACTIE'="VERKEER";
'Your Start Date Field' >= DatePicker1.SelectedDate && 'Your End Date Field' <= DatePicker2.SelectedDate
);
'GECONTROLEERDE PERSONEN'
)
Partially delegable version (this is better):
With(
{
_data: Filter(
'5366 - Acties (registratie)';
'SOORT ACTIE'="VERKEER"
)
};
Sum(
Filter(
_data;
'Your Start Date Field' > = DatePicker1.SelectedDate && 'Your End Date Field' <= DatePicker2.SelectedDate
);
'GECONTROLEERDE PERSONEN'
)
)
