XNPV Formula

[cireost]

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

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

Thanks.

[danilang · Accepted solution]

Hi @cireost 

Based on this formula

With the following inputs@10%

this workflow

will give you 

Dan