Answered

Sum based on filters

(1) Share

Report

Posted on by bB-27090143-0

Hi there,

Without applying filters I am getting total hours in Table2

However I cannot seem to apply the filters? I keep getting blanks

Any ideas???

I need to filter this based on :
Date DatePickerCanvas2_1
Employee Name ComboboxCanvas5_1

current formula not working as selected

Value not populating and selected items erroring

Sum(Filter(Datasource, Date = DatePickerCanvas2_1.SelectedDate, EmployeeName = ComboboxCanvas5_1.Selected.Value || IsBlank(ComboboxCanvas5_1.Selected.Value), 'Hours Qty')

I want to sum hours of hours quantity of truck driver time card based on selected values in date and employee name

Thanks

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (1)

Sort by

WarrenBelz 154,964 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi bB-27090143-0

Firstly you are missing a bracket
Sum( Filter( Datasource, Date = DatePickerCanvas2_1.SelectedDate, EmployeeName = ComboboxCanvas5_1.Selected.Value || IsBlank(ComboboxCanvas5_1.Selected.Value) ), 'Hours Qty' )

but you may have a Delegation limitation here so
With( { _Data: Filter( Datasource, Date = DatePickerCanvas2_1.SelectedDate, EmployeeName = ComboboxCanvas5_1.Selected.Value || Len(ComboboxCanvas5_1.Selected.Value) = 0 ) }, Sum( _Data, 'Hours Qty' ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,964 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Just following up to see if you received the answer you needed, or if you require further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No