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,