2 Replies Latest reply: Apr 18, 2014 12:18 PM by F. Arabak RSS

    Member Formula Percentage Calculation

    F. Arabak

      I have a DataType dimension in a BSO app that is used to calculate adjustments to historical data. It is a Label Only dimension with 3 members:

       

      Historical Value

      Adj%

      Calculated Adj (Dynamic member)

       

      Where I have placed the following member formula in CalculatedAdj: CalculatedAdj = HistoricalValue * Adj%

       

      When validating the above formula I get the following error "Error compiling formula for [] (line 1): invalid assignment"

       

      I'm guessing the formula is too simple and other parameters need to be included but I am at a loss as to what they are. I appreciate your help.