In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
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
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All