NPV Formula Implimentation

[AS]

Hi Experts,

I'm trying to implement NPV formula with dynamic values but could find the way to implement this. If I concatenate the values with coma separation, it will be converted into string show error into the formula.

Could you please help!

[caltang]

Are you trying to make an NPV calculator? You need a few dummy variables in order to do that, otherwise your error will not go away.

Kindly provide more context as to what you need, an expected output would be most helpful as well.

[AS]

Hi @caltang 

I'm yes, I'm trying to make NPV calculator. I uploaded the workflow showing expected result with static values. while doing calculation I wanted pull values from the column Transaction and using those values the NPV calculation should happen.

See the workflow below and let me know in case of any confusion.

[caltang]

Hi @AS

What you are doing is incorrect because you are calling a whole string into the NPV function. Because of that, it cannot compute.

What you need to do is to use the Cross-Tab tool to get what you desire.

[caltang · Accepted solution]

In addition to that, I went a step further for you @AS. I made it into an Analytic App whereby you can share with your users via Server or via Designer sharing. Users just have to input values and it will compute.

I hope this helps. Kindly drop a like / mark as accepted solution once you are happy with it.

Best,

Calvin

 

[AS]

Hi @caltang 

Thanks a ton. This really helps.