Financial Functions

Comments

3 comments

  • Avatar
    Jessica Orlando

    This is great! I just tried to implement this and am getting infinity and negative infinity symbols in my pivot table. When I do the calculation on the same numbers in Excel I get '0.00000029802322..%'.

     

    Is there a way around this or to code this to round to 0?

     

    Thanks!

     



    0
    Comment actions Permalink
  • Avatar
    Jason Justice

    Is this compatible with v7.3? I have installed the plug-in and see the Finance context menu, but none of the functions appear to perform a calculation--they just return the original input value. I've added sample portfolio data to follow your example as much as possible. Note that I've not been able to add a 3 part function the NPV (to include a discount rate), but that's an easier calculation to implement in the cube.

    1
    Comment actions Permalink
  • Avatar
    Jessica Orlando

    I am in the same position as Jason. I am trying to test this on 7.4 and it appears to just be returning the original input value.

    1
    Comment actions Permalink

Please sign in to leave a comment.