8 Replies Latest reply on Apr 3, 2012 10:32 PM by George_Johnson

    Help me convert this excel formula to javascript... PLEASE!


      Hi there,

      I've been tasked with converting an excel spreadsheet to a PDF from in Livecycle designer and can't figure out the formula for a specific function. The formula in excel is:


      The corresponding fields in Livecycle are as follows:

      B39 through B52 are Priority1.rawValue through Priority13.rawValue.

      S39 through S52 are Cost1.rawValue through Cost13.rawvalue

      I assume the field where the SUMIF is being perfomed would be this.rawValue.

      Thanks in advance for the help!