Print future date(s) on report

[Former Member]

Post Author: jennpo

CA Forum: Formula

I have a report that uses data from a table to collect sales by month and year. I've also created a formula that prints the forecasted sales by month and year. I use month and year from the sales table to group the data. I need be able to print the month and year forecasted sales on the report for dates in the future. Any ideas on how to make this work.

I was able to find a formula that will show data for dates not in a table but it works on a beginning and ending date and shows the missing dates in between. I need the dates after the last date in the table.

I appreciate any help I can get.

Jennifer

[Former Member]

Post Author: bettername

CA Forum: Formula

What you need is a table (or Excel spreadsheet if you can't create tables) that you link your existing table from (ie: new table --> left outer join --> sales table). This table (or sheet) should contain every date or month-year combo for the useful forseeable future.

Then group on the date in the new table, and you'll get dates (and empty groups) for those dates that have yet to appear in your sales table.

[Former Member]

Post Author: bettername

CA Forum: Formula

What you need is a table (or Excel spreadsheet if you can't create tables) that you link your existing report from (ie: new table --> left outer join --> sales table). This table (or sheet) should contain every date or month-year combo for the useful forseeable future.

Then group on the date in the new table, and you'll get dates (and empty groups) for those dates that have yet to appear in your sales table.