PO Spend Report - Filter data by date
Hi everyone, I have a relationship with Company<Purchase Orders I am summarizing a numeric field on the Company Table from the Purchase Orders Table for Total Committed Costs This way I can s...
Forum Discussion
I'm assuming you're referring to the embedded report the Company record, but I'm not clear on the relation to the summary fields. If you want to always show 3 years of data in an embedded report, you can do this a couple of different ways. Possibly the easiest would be to create a Formula Checkbox field on your PO table and build your criteria there. For this example, I would probably go with something like this:
You would then use this field in the filter for the Embedded Report.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Year([PO Date])>=Year(Today())-3You would then use this field in the filter for the Embedded Report.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Hi Blake, let me clarify the ask a little bit to make it clearer....
I am not using an embedded report but created a report showing the company name, their web site, services they provide (which is a field I have), and the summary field from the purchases order table showing committed spend.
Currently, the way I did this is to create two summary fields and two reports:
First summary field summarizes the dollar amount of all PO's from the PO table where PO date is during the current year. That gives me the current committed spend this year.
The second summary field summarizes the dollar amount of all PO's from the PO table for any date. That gives me the total committed spend all time for the vendor.
What I was getting at is sometimes I want to pull spend reports on different date ranges. I have a date field on the PO called PO Date. I do not want my VP of Supply to need me to create the report and date range on the backend all the time. I was hoping he could use a dynamic filter on the report to change that PO date range so it would summarize the data based on whatever selection he puts in there.
------------------------------
Ivan Weiss
------------------------------
