Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

IRR calculation in Alteryx

Highlighted
5 - Atom

I have to calculate IRR for each year i.e. my data set looks like this

 

YearAmount
FY1213 (7,443,899)
FY1314   3,471,213
FY1415   1,922,517
FY1516   1,325,174
FY1617   1,071,985
FY1718      864,698

 

I need to calculate IRR at each year interval. i.e. the output should be like below:

 

YearAmountIRR
FY1213 (7,443,899)NA
FY1314   3,471,213-53.4%
FY1415   1,922,517-20.8%
FY1516   1,325,174-5.9%
FY1617   1,071,9852.3%
FY1718      864,6987.0%

 

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.

 

Thanks,

Sumit

Highlighted
14 - Magnetar
14 - Magnetar

@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.

 

image.pngCheers!!

Esther

Labels