EPMComparison
Applies to: Planning and Consolidation connections. If you use this function on other connections, a simple subtraction is performed, since the account type cannot be retrieved.
Performs a better or worse comparison of two values, based on the account type property of the account member.
The account type property has the following values:
- INC (Income)
- EXP (Expense)
- AST (Asset)
- LEQ (Liabilities & Equity)
| Parameter | Description |
|---|---|
| connection name | Name of the connection. For details about the syntax you must use, see Connection Name Parameter - Syntax. |
| account | Name of the account member. Mandatory. |
| cell1 | Cell reference of one of the values in the comparison. Mandatory. |
| cell2 | Cell reference of the other value in the comparison. Mandatory. |
Note
- If the description of a member exists in several dimensions, once you have entered the function, a message appears, stating that the description is ambiguous and recommending that you use the ID of the member instead.
- If the ID of a member exists in several dimensions, once you have entered the function, a message appears, stating that the ID is ambiguous and recommending that you use the full unique name of the member instead.
Example
EPMComparison("Finance","Revenue",B2,C2). If cell B2 is greater than cell C2 and the account is a revenue (income) account, the resulting variance is expressed as a positive. If the account is an expense account, the variance is negative.