Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

XNPV Formula

cireost
8 - Asteroid
‎03-11-2019 01:21 PM

Does anyone know how to use or build an XNPV formula using alteryx? 

 

In excel, the XNPV formula is XNPV(rate,values,date).



Thanks.

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
danilang
19 - Altair
19 - Altair
‎03-12-2019 05:23 AM

Hi @cireost 

 

Based on this formula

formula.png

 

With the following inputs@10%

Inputs.png

 

this workflow

 

WF.png

 

will give you 

Result.png

 

Dan

XPNV.yxmd
Reply
0 Likes
apply to be an alteryx mentor
Join the tampa, florida User Group
Labels