Home Forums The XBRL API Calc! Error in Excel

Viewing 1 reply thread
  • Author
    Posts
    • #201714
      Timur Mirzaev
      Participant

      Hello!

      For some reason, my query, which used to work just fine (arguably, before the recent add-in update), now shows the “Calc!” error. What is even more unusual is that in a split of a second I can actually see the data appearing before being superseded by this very error.
      Apparently, this error can be replicated by having the full code written as a formula [ with references to other cells having, say, ‘fact endpoint’ and ‘textjoin(“,”, TRUE, concept name) formula for concept unification], while the XBRL.showData () is used separately to refer to that formula.
      Interestingly, if one “kills” the formula, so that the code is just a plain text, the error is gone, and data is extracted.

      I would very much appreciate any help around this issue.

    • #201818
      David Tauriello
      Keymaster

      Hi Timur – this link might help you diagnose the #CALC! issue: https://exceljet.net/formula/how-to-fix-the-calc-error

      If you post an example of a query that’s not returning data, it will be easier to understand the issue you’re encountering.

      David

Viewing 1 reply thread
  • You must be logged in to reply to this topic.

Comment

Upcoming XBRL US Events

Webinar: DQC Rules for BDCs and Public Companies – Rule Set 20
Wednesday, December 14, 2022

Communications & Services Steering Committee Meeting
Tuesday, December 20, 2022

Domain Steering Committee Meeting
Tuesday, December 20, 2022

Public Exposure for Comment – Data Quality Committee Rules and Guidance
Saturday, December 31, 2022