Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
I want to calculate IRR (IRR will be used in my NPV)
In excel IRR is done like so:=IRR(M31:M1048576)
I tried using this:
but this value doesnt make sense
calculate NPV I want to use these two values IRR and the column EIR-Recalc.
in excel NPV is like this =NPV(C78,M7:M65) , where C78 is IRR and the M7:M86 is the EIR-Recalc column
How can I calculate both of these?
I don't know anything about the formulas behind the calculations, but the Summarize Tool offers this calculation options for numbers, take a look into theese.
