You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Custom Calculation Example: FCCS_Closing Balance Input

Accepted answer
24
Views
7
Comments
edited Apr 26, 2021 4:37PM in Financial Consolidation and Close 7 comments

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" (

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!