Alteryx Designer Desktop Discussions

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

XNPV Formula

cireost
8 - Asteroid

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

 

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



Thanks.

1 REPLY 1
danilang
19 - Altair
19 - Altair

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

Labels