XIRR function does not return value

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,