It displays December 2009 data for most columns, and November 2009 data for the alternate date range column. Alternate Range TypesĪfter you add a column to a report, you can select one of the following alternate range types:ĭefined in relation to the overall date range set for the report.Ĭhanges when the overall report date range changes.Įxample: In December 2009, you add a column with an alternate date range of last month to a report and run it. See Financial Report Builder Edit Columns Page. For financial statements, use the Financial Report Builder to edit columns. See Choosing a Date or Period Range for a Report.Īlternate date ranges and period ranges for columns are set on the Edit Columns page of the Report Builder. You can change this range by editing the date filter on the Filters page, or by changing the selection in the date or period dropdown list on the report results page footer at run time. She can then also create a custom formula field that shows the variance between each year.Ī report's overall date range is set in a date filter on the Filters page of the Report Builder. She can include this data by adding multiple amount columns to the income statement and selecting an alternate date range for each column. After you add comparison columns to a report, you can also use them in formula fields to show variances between specific dates and date ranges.įor example, a CFO may want an income statement to compare dollar amounts between different fiscal years. Comparison columns can be added for any numeric value field available for a report, such as dollar amount or item count. To include data from multiple time periods, you need to create multiple report columns for the same field, and define a different alternate date range (or alternate period range) for each column. You can customize reports to include comparisons of values across different date ranges or period ranges.
0 Comments
Leave a Reply. |