Share
Report
31So I am working on an app that needs to sum the column Timer, which is then filtered by Agent Name, Order Type, as well as a date range. I think I have found code that will allow me to add the times from the Timer column together, but since this list is actively being used I am not sure if data being displayed is correct. I am unsure where I need to place the filter in the code and where I did add a filter for agent name I received nothing in return. The code I am using for adding the times in the timer column is as follows:
RoundDown(Sum(AddColumns(OrderEntryList,"NewRow",Value(First(Split(Timer,":")).Result) * 60 + Value(Last(Split(Timer,":")).Result)),NewRow) / 60,0) & ":" & Mod(Sum(AddColumns(OrderEntryList,"NewRow",Value(First(Split(Timer,":")).Result) * 60 + Value(Last(Split(Timer,":")).Result)),NewRow),60)
I need to now filter using 4 different Dropdown menus. One is Agent Name=DRPAgentName.SelectedText.Value, Order Type=DRPOrderType.SelectedText.Value, OrderDate>=DRPBeginningDate.SelectedText.Result, OrderDate<=DRPEndingDate.SelectedText.Result
It is my hope once I get this figured out I will be able to make the app display time to complete each order type and how many pieces per hour are being ordered. Thank you for any insight.
All responses (
Answers (
