Forum Discussion

LeithSimpson's avatar
LeithSimpson
Qrew Member
5 years ago

Large Calculated Summary Field Doesn't Load Correctly Immediately and Shows 0 Temporarily...Sometimes

Hi, So I'm running into an interesting situation where I have a particular calculated/summarized value is summed up across enough data, that if it's been a while since I (and probably others) have ...
LeithSimpson's avatar
LeithSimpson
Qrew Member
5 years ago
Here are a couple screenshots. "Wrong value" is a screenshot from when I first logged into quickbase just now. "Correct Value" is when I reloaded a few seconds later. No changes to the data in the interim. And no other differences in the overall summary report other than that value.

------------------------------
Leith Simpson
------------------------------
  • LauraThacker's avatar
    LauraThacker
    Qrew Captain
    5 years ago
    It is not clear from your screenshots if you are displaying this data on a form, or as a report.

    If you are displaying some kind of embedded report on a Form Layout (record); and you possibly have more than 1 embedded table from the same source table; this could be an issue.

    If this is not the case; then I would recommend submitting a Support Ticket; so that Quick Base can actually see your App and diagnose the possible source of this directly.

    ------------------------------
    Laura Thacker (IDS)
    laura@intelligentdbs.com
    (626) 771 0454
    ------------------------------
    • LeithSimpson's avatar
      LeithSimpson
      Qrew Member
      5 years ago
      Thanks for the reply Laura.
      It's a summary report. I didn't want to share a full screenshot due to confidentiality.
      I'll submit a Support Ticket.

      ------------------------------
      Leith Simpson
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        5 years ago
        The only times that I have seen Auick Base not calculate correctly, regardless of the crazy complexity of the app, is in two situations.

        1. You have a summary field where the reference field on the right side itself uses a lookup field as part  of it's formula.  

        2. You actually have a circular calculation.  Quick Base mostly prevents you deform doing this but if you have complex summary fields there may be a hidden circular calculation that Quick Base can't stop you from creating.


        ------------------------------
        Mark Shnier (YQC)
        markshnier2@gmail.com
        ------------------------------