Financial Functions



  • 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?




  • 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.

Please sign in to leave a comment.