Cell-level calculations for Line Definitions used by Input Definition are constructed in the same manner as detailed in the Cell-level Calculations in the Line Definition Formula field section. In short, the formula field (or using the Calculation window for that field) are fundamentally constructed using the column “Code” cell reference and the period (.) to delineate between column and value. However, when the Input Definition is opened for the Data Input workspace, only the cell referenced by that calculation will be locked on the line. Any other cells will be available for input.
EXAMPLE:
A row in a Line Definition used by an Input Definition is required to calculate a specific percentage overage for the month of February. The value will be a 15% overage on the amount specified for the previous month (January).
The Line Definition includes the following:
Code |
Segment (Natural Account) |
Formula |
7375 |
7375 |
C=[B].[7375]*1.15 |
The Calculation Engine will appear as follows:
The Column Definition includes the following:
Header 1 |
|
Jan |
Feb |
Mar |
Code |
A |
B |
C |
D |
Type |
Row Definition Description |
Balance |
Balance |
Balance |
Book Code |
|
Budget_Original |
Budget_Original |
Budget_Original |
Year |
|
Year |
Year |
Year |
Period |
|
1 |
2 |
3 |
Value Type |
|
Periodic |
Periodic |
Periodic |
Your Input Definition workspace with the placement calculation in the row Code = ‘7375’ would return a calculated amount based on the value entered for January. In this instance, February returns a value of 28.75 (i.e. 25*1.15):
The calculated value for February cannot be manually updated.