Dynamically/Alteryx App change discount rate in summary NPV calculation

[wonka1234]

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

Read this article and consider marking the solution if you're all set. Thanks.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

[wonka1234]

@Luke_C  Hi luke,

the numbers generated by your macro are slightly off from what it should be.. It should be 

but im getting 

[Luke_C]

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.

[apathetichell]

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.