Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
@CalcMgrExcelXIRR with @XRANGE — Cloud Customer Connect
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

@CalcMgrExcelXIRR with @XRANGE

Received Response
11
Views
7
Comments

Summary: I am trying to implement excel's XIRR function using @CalcMgrExcelXIRR. When I run this function within the year (using XRange) it works fine but XRange across the years doesn't work and return 0.


Content (required): For Example:

@CalcMgrExcelXIRR(

@REMOVE(@XRANGE("FY21" -> "[YearTotal].[Jul]" -> "FinDev_DevIRR_TotalCF", "FY21" -> "[YearTotal].[Jun]" -> "FinDev_DevIRR_TotalCF"), "FY21" -> "BegBalance" -> "FinDev_DevIRR_TotalCF"), 

@REMOVE(@XRANGE("FY21" -> "[YearTotal].[Jul]" -> "FinDev_PeriodEndDate_Excel", "FY21" -> "[YearTotal].[Jun]" -> "FinDev_PeriodEndDate_Excel"), "FY21" -> "BegBalance" -> "FinDev_PeriodEndDate_Excel")

, 0.2

);


but it does not work and return 0 when I cross over the year in XRange function (code as below).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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