Hi all,
is there a way I can alter or have a dynamic input (alteryx app) with the summarize npv function?
Thanks.
Hi @wonka1234
It looks like you can update this with the action tool, so yes it can be updated via a user input in the app interface or be updated as part of a batch macro.
@Luke_C thanks luke.
Is it possible for me to take this value from another field? I want it to be updated from the IRR summarize from another tool.
Hi @wonka1234 Yes if you do it via a macro you can pass the field in as a control parameter. If you have sample data I could mock something up.
@Luke_C
please see attached file with mockup
@Luke_C any luck?
@wonka1234 Bit confused with what you attached. I don't see a field with the rates. It looks like you figured out the user input but I thought that wasn't the approach you wanted to take?
I want to use the Irr calculation number as my input (discount rate) into the npv calculation.
@wonka1234
Here's an example based on your data. Hopefully this helps.
I have an error opening,
This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version. Alteryx does not support using an earlier version of Alteryx to open a workflow created with a newer version. For best results, download the latest version of Alteryx
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/ba-p/779546
@Luke_C Hi luke,
the numbers generated by your macro are slightly off from what it should be.. It should be
but im getting
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.
