BrandiSullivan
Qrew Member
Joined 4 years ago
User Profile
User Widgets
Contributions
Getting Report Formulas to follow Date Range filter rules
I have entered a report formula into my report to show all call types related to a user's ID # in the same column. For example, if user ID 123456 had one call on 5/1/22 for Call Type A and one call on 5/18/22 for Call Type B in the data table, the report would show only one line for user ID 123456 and in the Call Types column it would list both A and B showing that in the data user ID 123546 has had calls for both Call Types A and B. In my report I then added a filter to filter the report by a date range which would be selected by the user (Date of call is on or after <ask user> AND Date of call is on or before <ask user>). The report formula is not following the report filter I have added. For example: Expected Result - If the date range entered is 5/1/22 to 5/10/22, the report will show one line of date for user ID 123456 and only show the call type A that is in the data table for the call that came in on 5/1/22. Actual Result - If the date range entered is for 5/1/22 to 5/10/22, the report shows one line of data for user ID 123456 but in the call type column it still shows Call Types A and B even though Call Type B came in on 5/18/22 which was outside of the date range I selected for my filter. How do I get my report formula to only show results for the date range I have selected? ------------------------------ Brandi Sullivan ------------------------------