Question

XIRR function does not return value

  • 24 October 2023
  • 2 replies
  • 58 views

Badge

Hello, I am using this formula to calculate the IRR amount, but it does not return anything. Could anyone help please ? Thanks in advance.

IF(CoC<1,XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],-0.2,FALSE,Day),XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],0.1,FALSE,Day))

 

 


2 replies

Userlevel 6
Badge +12

Hi, 

I suggest:

  • opening the formula playground from your formula bar and switch to automatic mode,
  • trying to play with your formula using /*comments*/ to isolate parts of your formula, for example if you remove your filter, do you have results:
    IF(CoC<1,XIRR(Amount[ADD: Company]/*[filter: LEFT('Transaction ID'.Name,8) = Company.Company]*/[BY SUM:'Transaction ID'],-0.2,FALSE,Day),XIRR(Amount[ADD: Company][filter: LEFT('Transaction ID'.Name,8) = Company.Company][BY SUM:'Transaction ID'],0.1,FALSE,Day))
    or
    if you just run your XIRR function, do you have results?
    or
    if you just run your condition CoC<1, do you have results?
  • is your formula aligned? are your target metric dimensions aligned with CoC and Amount?
  • Ensure you have source data in your metrics?

 

Please let us know, and ultimately, please create a Support ticket.

Hope it helps.

Best,

Userlevel 6
Badge +12

Hi,

 

Have you found a solution maybe?

Does this situation require more assistance?

 

Best,

Reply