EvPRO Formulas

Show TOC

You can use EvPro formulas to enhance your Planning and Consolidation reports.

Prerequisites

The property YEAR exists for the formula that links the year to the Category dimension.

The Category dimension has a COMPARISON property for the dynamic comparison category.

Features

You can use the Dynamic link and the Dynamic comparison category features as outlined below.

Dynamic link — Year to Category dimension

This formula links the year to the current category displayed in the current view so that the year cannot be changed in the current view Time dimension. You can change the other Time dimensions (Month, Quarter). This formula prevents the system from displaying irrelevant data. For example, in the Budgeting application you have a category called budget2008. You can link the year 2008 to this category so that a report using the budget2008 category displays data for only the year 2008. Data from any other year is irrelevant in this instance and this formula prevents such data from being displayed.

Syntax Syntax

```
EVPRO(AppName,Category,year)&.&Period
```

End of the code.

Example Example

Below is an example of the dimension Category property (YEAR) that you need for this formula. In this example, if you are in the Finance application and the current view is set to Budget, the year is set to 2008. If you change the current view to FCST, the year is set to 2007.

	A	B	C	D
1	ID	NEWID	DESCRIPTION	YEAR
2	ACTUAL		ACTUAL	2007
3	BUDGET		BUDGET	2008
4	BUDGETV1		BUDGET VERSION 1	2008
5	BUDGETV2		BUDGET VERSION 2	2008

End of the example.

Dynamic comparison category

This formula dynamically links a comparison category to the category in the current view.

Syntax Syntax

=EVPRO(application,CurrentView Category Cell reference,comparison)

End of the code.

The system inserts the category designated as a comparison Category to Budget into the comparison column.

=EVPRO(Finance,Budget,Comparison)

Example Example

The following table shows an example of how the Category dimension uses the COMPARISON property. In the example, if the current view is set to ACTUAL, the comparison category is BUDGET. If the current view is set to Budget, the comparison category is Forecast. If the Category dimension does not contain this property, see your administrator.

	A	B	C	D	E
1	ID	NEWID	DESCRIPTION	YEAR	Comparison
2	ACTUAL		ACTUAL	2007	BUDGET
3	BUDGET		BUDGET	2008	FCST
4	BUDGET		BUDGET VERSION 1	2008	FCST
5	BUDGET		BUDGET VERSION 2	2008	FCST
6	BUDGET		BUDGET VERSION 3	2008	FCST
7	FCST		FORECAST	2007	ACTUAL

End of the example.

More Information

EvPRO