CODEWITHSUNDEEP
powerappspowerapps-formula
next_Bill
next_Bill

Reputation: 1

powerapps Items Function - DataTable - Need to filter zeros in a column & return a grand total at the bottom of table

I need help with the formula below. It's currently in the Items function of a datatable.

Could we not show the rows if the value in the data table column is zero. The data table column is "Recorded Time" in Timesheet_DataTable_Container. The source of the data is called October_Timesheets_1D.

Lastly in the same function could we add a grand total table for the Recorded Time column. Something like this:

Total Hours: 180

Sort(
  Filter(
    October_Timesheets_1D,
    WinTeam_ID = employee_search.Text &&
    DateValue(Date_Formatted) >= ddTimeSelection.Selected.StartDate &&
    DateValue(Date_Formatted) <= ddTimeSelection.Selected.EndDate
  ),
  Date, SortOrder.Descending
)

Thanks you for your help.

I tried the removeif formula. I don't know how to use PowerApps formulas yet. I added the formula to the end of the function I have.

Error 1

Error 2

Upvotes: 0

Views: 101

Answers (1)

Sam Nseir
Sam Nseir

Reputation: 12111

If I understood your question correctly, then add the additional conditional to your filter:

Sort(
  Filter(
    October_Timesheets_1D,
    'Recorded Time' <> 0 &&
    WinTeam_ID = employee_search.Text &&
    DateValue(Date_Formatted) >= ddTimeSelection.Selected.StartDate &&
    DateValue(Date_Formatted) <= ddTimeSelection.Selected.EndDate
  ),
  Date, SortOrder.Descending
)

And for your total hours, you could try:

Sum(
  Filter(
    October_Timesheets_1D,
    'Recorded Time' <> 0 &&
    WinTeam_ID = employee_search.Text &&
    DateValue(Date_Formatted) >= ddTimeSelection.Selected.StartDate &&
    DateValue(Date_Formatted) <= ddTimeSelection.Selected.EndDate
  ),
  'Recorded Time'
)

Upvotes: 0

Related Questions