Question

# XIRR function does not return value

• 2 replies
• 331 views

• Just Arrived
• 0 replies

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
+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
+12

Hi,

Have you found a solution maybe?

Does this situation require more assistance?

Best,