Custom Calculation Example: FCCS_Closing Balance Input
Content
Does anyone have an example of a calculation they have used to successfully create a block for FCCS_Closing Balance Input when the data file submits an Ending Balance of 0?
I have been working with different versions of the calculation below that says if "FCCS_TotalOpeningBalance" equals "FCCS_ClosingBalance" Then create block for "FCCS_ClosingBalance_Input" but haven't had any luck.
Thank you in advance!
FIX
(
@REMOVE(@LEVMBRS("Account", 0), @LIST(@RELATIVE("FCCS_System Account", 0), @RELATIVE("FCCS_Drivers", 0), @RELATIVE("Exchange Rates", 0))),
FCCS_No Intercompany",
LDESCENDANTS("Total Business Unit"),
"No Custom 2",
"FCCS_Managed Data",
"FCCS_Periodic"
)
"FCCS_ClosingBalance_Input" (
0