XIRR Formula

umairah

Hi, I need help with calculating XIRR formula

My data has deal_id, flow_date & cashflow amount. Refer to image below.

I want to calculate whenever new date detected the rate will be recalculate. For example: if the deal_id & flow_date is the same then the XIRR will be calculated. I have checked the function in the formula tool but don't quite understand it. I have attached sample data for your reference. 

Really appreciate the help

Thank you in advance!!

sample data for XIRR.yxdb

Qiu

@umairah 
This is a new Function for me. 😁

This is a thread we can refer.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Stacked-XIRR-Calcs/td-p/643535

The is an issue with your data which is that there should be at leat one negative value as per help of Microsoft Excel.
I tried with the sample in below and get the same result.

https://support.microsoft.com/en-us/office/xirr-function-de1242ec-6477-445b-b11b-a303ad9adc9d

XIRR expects at least one positive cash flow and one negative cash flow; otherwise, XIRR returns the #NUM! error value.

 

0412-umairah.yxzp