Skip to main content
Nintex Community Menu Bar

Calculating IRR (Internal Rate of Return) in Nintex or Calculated columns

  • December 31, 2019
  • 2 replies
  • 14 views

Forum|alt.badge.img+1

Hey everyone

 

Long-time lurker (thank you for everyone on this community that has solved many mini-queries for me over the last year or so!).

 

I have a loan cashflow in a Sharepoint List (one column per payment) and am hoping to find a way to calculate the IRR. In Excel this is simply IRR(<range>,<accuracy>) but this isn't available in Sharepoint OOTB - i expect because it's not a simple calculation and the "range" isn't as defined in columns.

 

Is anyone aware of a way i can calculate this using Nintex?

2 replies

Forum|alt.badge.img+12
  • Scholar
  • December 31, 2019

@DC89 .....I think you can do it with Nintex workflow. Using for loop/while loop you can build the formula.


Forum|alt.badge.img+1
  • Author
  • January 2, 2020

Thanks Kunal. I thought there might be a way. I'll do some digging into how to create a "manual" IRR and then replicate it into a Nintex loop.