Hi all,
is there a way I can alter or have a dynamic input (alteryx app) with the summarize npv function?
Thanks.
@Luke_C Hi luke,
the numbers generated by your macro are slightly off from what it should be.. It should be
but im getting
Hi @wonka1234
How are getting your answer? Check the rates used, is one being rounded off or something? Otherwise I wouldn't be sure - the macro just populates the % input in the summary tool.
Are you using the summarize tool for NPV or IRR? If it's NPV why not just use a formula tool and then running total? The summarize tool does not allow for the customization that you need when you are doing an NPV model.