Skip to main content

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))

 

 

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(AmounttADD: Company]/*>filter: LEFT('Transaction ID'.Name,8) = Company.Company]*/>BY SUM:'Transaction ID'],-0.2,FALSE,Day),XIRR(AmounttADD: 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,

Hi,

 

Have you found a solution maybe?

Does this situation require more assistance?

 

Best,

Reply


Ask your question here!

Terms & ConditionsCookie settings