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 

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.

[wonka1234]

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

[Luke_C]

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.

[wonka1234]

@Luke_C 

please see attached file with mockup

[wonka1234]

@Luke_C  any luck?

[Luke_C]

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

[wonka1234]

@Luke_C 

I want to use the Irr calculation number as my input (discount rate) into the npv calculation.

[Luke_C]

@wonka1234 

Here's an example based on your data. Hopefully this helps.

[wonka1234]

@Luke_C 

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