Troubleshoot XNPV formula please

  • Resolved tda325

    (@tda325)


    8 years ago

    There’s got to be a bug here as it returning blank, but I just can’t see it:
    Site: https://www.SourceEO.com

    NROUND(XNPV(fieldname311,
    [-1*fieldname319,
    (blicons+fieldname247+fieldname250)*(1+fieldname335),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,2)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,3)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,4)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,5)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,6)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,7)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,8)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,9)),
    (blicons+fieldname247+fieldname250)*(1+POW(fieldname335,10))],
    [’01/01/2001′, ’01/01/2002′, ’01/01/2003′, ’01/01/2004′, ’01/01/2005′, ’01/01/2006′, ’01/01/2007′, ’01/01/2008′, ’01/01/2009′, ’01/01/2010′, ’01/01/2011′]))
    .
    Where:
    fieldname311 = Calculated IRR
    fieldname319 = initial net investment
    (blicons+fieldname247+fieldname250)= net cost savings impacts
    fieldname335 = inflation rate
    .
    Of course, I don’t have the carriage returns in there when I plug it in, I posted it this way so as to make it easier to see.

    also note that all of these variables are being called for in other fields that DO work, so I don’t believe that they are the problem.
    Thanks!

    • This topic was modified 8 years ago by tda325.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter tda325

    (@tda325)

    caught the extra “close parentheses” and did some additional equation simplification. Still returns blank. Current equation is:
    .
    NROUND(XNPV(fieldname311,
    [-1*fieldname319,
    (blicons+fieldname247+fieldname250)*fieldname335,
    (blicons+fieldname247+fieldname250)*POW(fieldname335,2),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,3),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,4),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,5),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,6),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,7),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,8),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,9),
    (blicons+fieldname247+fieldname250)*POW(fieldname335,10)],
    [’01/01/2001′, ’01/01/2002′, ’01/01/2003′, ’01/01/2004′, ’01/01/2005′, ’01/01/2006′, ’01/01/2007′, ’01/01/2008′, ’01/01/2009′, ’01/01/2010′, ’01/01/2011′]))

    Thread Starter tda325

    (@tda325)

    That “N” in front of “ROUND” was staring me in the face. Eventually, I spotted it..

    • This reply was modified 8 years ago by tda325.
    Plugin Author codepeople

    (@codepeople)

    Hi @tda325,

    Yes you are right, the operation is “ROUND”, and not “NROUND”

    Please, for future questions related to specific equations, I will need a link to your webpage to check it in action, because some issues may be related with the values of fields, and not with the equation’s structure.

    Best regards.

    MarcoGuiotto

    (@marcoguiotto)

    Hi, once again I’m very sorry to bother you here, but I’m getting no reply to the ticket #187257 on your premium support system from K.Danson, I have sent several messages and emails. We have some deadlines approaching and have been awaiting for an answer since Mon, Oct 24 2016 1:03pm…

    Plugin Author codepeople

    (@codepeople)

    Hi,

    Please check the answers in your support ticket #187257

    Thank you!

    • This reply was modified 8 years ago by codepeople.
    MarcoGuiotto

    (@marcoguiotto)

    Thank you, got it and replied straight away.

    Regards

    Marco

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Troubleshoot XNPV formula please’ is closed to new replies.