49
This function uses the FDM Lookup function to add another source account from a different
source center, FDM category, and FDM period to the value of the logic account if the active
location is “Texas.”
If strLocation = “Texas” then =
RESULT = CURVAL + |000,10,09/30/01,810|
Else
Result=”Skip”
End If
Expression Operator (Exp)—Used to execute a custom logic expression defined in the Value/
Exp field. Logic expressions are simpler than logic functions but cannot use variables or
If
statements. Expressions do not have built-in parameters except for
|CURVAL|
which must be
enclosed in pipes. There is no need to assign the value of an expression to the
RESULT =
constant
like in logic functions. Expressions execute faster than logic functions. The FDM Lookup
function can be used within an expression in the same manner as within a logic function. To
write a custom expression, double-click the Value/Exp field to open the expression editor.
The following are examples of custom logic expressions:
|CURVAL| + |810| + |238|
This function uses the FDM Lookup function to add two source accounts to the value of the
logic account. Notice that the CURVAL parameter can be used within expressions as in logic
functions except that it must be enclosed in pipes.
(|CURVAL| + |000,10,09/30/01,810|) * 100
This function uses the FDM Lookup function to add another source account from a different
center, FDM category, and FDM period to the value of the logic account and multiplies the entire
result by 100.
FDM Lookup—Use this function to return the value of any source account that resides in FDM.
This function can be used within a logic function or within a logic expression.
To return a value of a source account for the active logic account source Center, FDM category,
and FDM period, use the following format:
Syntax: |GLAcct|
Example: |810|
To return the value of a GL account for a different GL Center, FDM category key, and FDM
period use the following format:
Syntax: |GLDept , CategoryKey , PeriodKey , GLAcct|
Example: |000, 10, 12/31/01, 810|
You can also use a combination of formats. The following example uses the default source center
and FDM period but specifies a particular FDM category key.
|, 10 , , 810|
72
L
og
i
c
A
ccounts