Revenue By Project with Date Range Prompt

[CalvinFold]

I have a report (type = Project) that is Revenue by Project. It has the following fields: Project Name Project Ref. # Project Owner Project Budget (custom field) Actual Revenue Actual Expense Total Revenue: SUM({actualRevenue},{actualExpenseCost}) The finance person who uses this would like a prompt so they can filter this by a particular month, or at minimum, a prompt which lets her put in a date range. I couldn't seem to suss-out what field to use for the prompt...wasn't sure which, if any, dates would be applicable. Thanks in advance! Kevin Quosig

[MirandaRa1]

If I have understood you correctly....report settings >> report prompt Then select project >> entry date and save - when the report loads you will have a report where you can select the date.... You are using a calculated expression, so i may be providing a solution that is too simply for what you want... For ranges outside of the list of choices - https://experience.workfront.com/s/article/Wildcard-Filter-Variables-810113772 For more complex prompts - https://experience.workfront.com/s/article/Working-with-Prompts-1898074737?language=en_US&r=158&ui-f... - custom prompts here Miranda Rais GVC