How to handle multiple IF's in a calc?

9:50AM

Summary:

Hi, working a calculation that when I input into 2 specific movements (available to input all Balance sheet accounts), the calc must add the offset in the default movement of that account, (app using ClosingBalanceInput rule).

1. What's the best way to tag these default movements?
2. Is there a way to avoid hardcoding all ?
3. How to handle multiple IF's?

(No groovy, Essbase only)

——

Calc draft (it does work)



FIX ("FCCS_Periodic", "FCCS_No Intercompany", "No Custom1", "No Custom2") 

    FIX (@REMOVE(@RELATIVE("FCCS_Total Balance Sheet", 0), @LIST("FCCS_BALANCE", "FCCS_CTA", "FCCS_Retained Earnings Prior", @UDA("Account", "Revenue"), @UDA("Account", "Expense"))), @REMOVE(@RELATIVE("FCCS_Mvmts_Subtotal", 0), @LIST("Inputmvt1", "Inputmvt2")))

How to handle multiple IF's in a calc?

Howdy, Stranger!