Sum Function for Data table

[AliciaDG]

Hi,

I have a data table that pulls data from a dropdown box and pulls information from a table.

What i am trying to do is figure out what the total number of Adults and kids where at a location.

Also i am stumped on how to have a date as a filter as well that is connected to the data table.

Thank you 

[WarrenBelz]

Hi @AliciaDG ,

This is the long way around, but when I try to shorten it for you, you seem to get errors. I have to assume the code you posted works when modifying as below.

Search(
   If(
      DDCampusLocation.Selected.Result = "All" And DDServiceLocation.Selected.Result = "-",
      Filter(
         Church_Online,
         Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
      )
     'DDCampusLocation'.Selected.Result = "All" And DDServiceLocation.Selected.Result <> "-",
      Filter(
         Church_Online,
         'Please select the service you joined (QLD Time)?' = DDServiceLocation.Selected.Result &&
         Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
        ),
      'DDCampusLocation'.Selected.Result <> "All" And DDServiceLocation.Selected.Result = "-",
      Filter(
         Church_Online,
         Title = DDCampusLocation.Selected.Result && Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
      ),
      'DDCampusLocation'.Selected.Result <> "All" And DDServiceLocation.Selected.Result <> "-",
      Filter(
         Church_Online,
         Title = DDCampusLocation.Selected.Result And 'Please select the service you joined (QLD Time)?' = DDServiceLocation.Selected.Result &&
         Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
      )
   ),
   TextSearchBox1.Text,
   "Name_x003a_",
   "Is_x0020_this_x0020_a_x0020_crea",
   "Please_x0020_select_x0020_the_x0"
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[AliciaDG]

Hi Again @WarrenBelz ,

thanks for your patience with this! Def one step closer 🙂 

below function isnt returning any data. there are also no errors? Any idea what i could have done wrong?

Search(
If(
'DDCampus Location'.Selected.Result = "All" And 'DDCampus Location'.Selected.Result = "-",
Filter(
Church_Online,
Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
),
'DDCampus Location'.Selected.Result = "All" And DDServiceLocation.Selected.Result <> "-",
Filter(
Church_Online,
'Which Campus are you joining from?'= 'DDCampus Location'.Selected.Result && Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
),
'DDCampus Location'.Selected.Result <> "All" And DDServiceLocation.Selected.Result <> "-",
Filter(
Church_Online,
'Which Campus are you joining from?' = 'DDCampus Location'.Selected.Result And 'Please select the service you joined (QLD Time)?'= DDServiceLocation.Selected.Result &&
Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
)
),
SearchBox.Text,
"Name:",
"Is this a creative gathering",
"Please select the service you joined (QLD Time)?"
)

[WarrenBelz]

Hi @AliciaDG ,

This is very difficult without seeing your data however if you put this in

If(
   'DDCampus Location'.Selected.Result = "All" And 'DDCampus Location'.Selected.Result = "-",
   Filter(
      Church_Online,
      Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
   )
)

do you get any data when the items selected on your screenshot are chosen? Also are you sure there are entries on that date?

[AliciaDG]

No data shows up i dont know what i am doing wrong.

[WarrenBelz]

@AliciaDG ,

Some basic debugging - break it down until you get something that works and then add bits back in until it stops - then you will know where the error is. Put a date picker and see if this gets data

Filter(
   Church_Online,
   Text('Date of Service Joined:',ShortDate)= Text(DatePicker4.SelectedDate,ShortDate)
)