Using Finance Aggregate Filters

Date Range

• This Fiscal Year
• Previous Fiscal Year
• Next Fiscal Year
• Any start to end month
• All Fiscal Years
• Trailing 12 months
• Next 12 months
• This Fiscal Qtr
• Previous Fiscal Qtr
• Next Fiscal Qtr
• This Fiscal Year Q1
• This Fiscal Year Q2
• This Fiscal Year Q3
• This Fiscal Year Q4
• Current Month
• Previous Month
• Next Month

The range of months that are used to generate the aggregate value of the Total, Group1, Group 2 etc., columns in the aggregate reports. For Monthly reports, this determines the months that will be populated in the output, all other months will have 0 values.

For Annual totals, use one of the different Fiscal Year choices. For Quarterly totals, use one of the different Quarter choices. If you want totals for a particular month, use one of the Month choices. For a range of months, use "Any Start or End Month"

You can choose aggregation of past or of future months.

Finance Dataset

• Current
• Current Before This Month
• Current After This Month
• Current Before Lock Month
• Current After/Including Lock Month
• Plan
• Plan Before This Month
• Plan After This Month
• Plan Before Lock Month
• Plant After Lock Month
• Current Before This Month, Plan After This Month
• Current Before Lock Month, Plan After Lock Month

This filter determines which set of month-by-month values for the Date Range specified above are considered for aggregation in the Aggregate reports, and which finance values are fed into the month-by-month columns as non-zero in the Monthly reports.

For each project, the system displays by default the "Current" values in the Finance page, and it is automatically updated from the Project Activities or from the Project Team Finances (provided the Finance Template has been configured to receive these values).

You can also take Snapshots of the "Current" value and store this as a "Plan" and not have it updated as edits are made or as the Project Activity and Project Team finances change.

This Filter allows you to select which Dataset (Current or Plan) you are interested in outputting in the report. If you are using Lock months to lock finances, the filter also allows you to consider the Lock month in generating the aggregate for the other months. For example, you can choose to take values from before the Lock month if you go through a finance validation that ensures that the numbers before the Lock month have been checked.

Further, the filter allows you to also consider this month (when the report is run) and take the Plan values from before this month and the Current values from after (and including) this month.

Snapshot for Plan

• Default Plan Snapshot

If the Finance Dataset filter refers to a Plan value, then the "Snapshot for Plan" further defines which of the Snapshots should be used for the report output.

The Default Plan Snapshot is always at the top of the list.

The system shows the complete list of all Snapshots taken in the drop-down list (up to a limit of 100). To ensure consistent aggregation of values, it is recommended that all users that make snapshots use a consistent naming scheme.

Finance Detail Level

• Total
• Group
• Category
• Element

The filter sets the level of detail of the Finance element hierarchy that is shown in the report. This also sets the number of rows in the output per project.

Total: means show only the top level (Total).

Group: means show the Group level, one level below Total (up to 5, depends on number of Groups configured).

Category: means show the Category level, 2 levels below Total.

Element: means show the Element level, 3 levels below Total

Show Upper Levels

• Yes
• No

This filter decides if the output should show higher levels of the Finance items hierarchy when a lower level item is chosen in the Finance Detail Level filter above

This is relevant if you are doing your own aggregation of the element level values using Excel and you do not want the Category, Group, Total level values to interfere with this aggregation.

Starting Month

Enter the starting month. This output setting decides which set of months will be shown in the report output.

Number of Months

Enter the number of months. For instance, you may set the number of months to 36 starting with January 2010 for several runs of this report. Then depending on the Date Range filter setting (above) varying sets of months of these 36 will be populated for different runs of the report.

Break down Finance Details by Organization

If this check box is selected, then each finance line is expanded and broken down by organization finance allocation.

Note: This report is usable only if the finance allocation percent total is exactly 100%. The system displays a warning message if it does not equal 100%.