locked
One or more formulas have an error RRS feed

  • Question

  • I am getting a 'one or more formulas have an error' warning from the tab of my date dimension while viewing in data view, but that table does not have a calculated column.  So I do not understand why it is complaining

    Tuesday, December 3, 2013 1:55 AM

Answers

  • Hi Jeffrey -

    May be an "Implicit" calculated field.  The ones that get created automatically when a user drags a regular field into the Values area within an Excel pivot.

    If you go to the Advanced tab and select "Show Implicit Calculated Fields", if there are any, they should appear in the grid at the bottom.  Then you can modify the formula as needed.

    Let me know if that helps.


    Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com

    Tuesday, December 3, 2013 4:21 AM
    Answerer

All replies

  • Hi Jeffrey -

    May be an "Implicit" calculated field.  The ones that get created automatically when a user drags a regular field into the Values area within an Excel pivot.

    If you go to the Advanced tab and select "Show Implicit Calculated Fields", if there are any, they should appear in the grid at the bottom.  Then you can modify the formula as needed.

    Let me know if that helps.


    Brent Greenwood, MS, MCITP, CBIP // Please mark correct answers and helpful posts // http://brentgreenwood.blogspot.com

    Tuesday, December 3, 2013 4:21 AM
    Answerer
  • Actually it was one of my calculated fields that was defined incorrectly, but it was your advise that got me the answer.  thx
    Tuesday, December 3, 2013 2:03 PM