Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

user13507279 Rank 1 - Community Starter

Comments

  • Let me illustrate through another concrete example: FY20 FY21 FY22 MIR Customer Interest Received 1000 2000 3000 MIR NII Payable -150 -200 -300 NII 850 1800 2700 I want to calculate NII which is equal to "Interest Receivable" + "Interest payable". Seems easy to calculate through script, formula or hierarchy consolidation…