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

  • 31 December 2019
  • 2 replies
  • 2 views

Badge +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

Badge +12

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

Badge +1

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.

Reply