This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have to calculate IRR for each year i.e. my data set looks like this
I need to calculate IRR at each year interval. i.e. the output should be like below:
However, using the summarize tool in Alteryx only returns IRR from period FY1213-FY1718 i.e. 7.0%.
Is there a way to get the result I am trying to achieve.
@sumitharsh, does this work for you?
Created a running IRR macro for this process. It runs row 1, then row 1-2, row 1-3, up through row 1-n where n is the last record in the data set.