Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Summary field won't display, average of hourly wage(currency)

Hey Everyone, Wanted to get some advice, I'm trying to pull an hourly wage from a different table as a summary field into another to display the 'average' of that sections hourly wage, when I go th...
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
Can you check if any of your record have blank values for the rate?  If so, you will need to add a filter where the the rate is not blank.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • AlexBennett3's avatar
    AlexBennett3
    Qrew Trainee
    5 years ago
    Nope isn't blank

    ------------------------------
    Alex Bennett
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago

      Is the relationship setup properly?  Do parents have child records that you can see on the parent record?  Do children have lookup fields to "prove" that they are children of the parent records?



      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • AlexBennett3's avatar
        AlexBennett3
        Qrew Trainee
        5 years ago
        Maybe I have this set up wrong. The Idea is that I have two tables, Labor Rates and Schedules. I'm attempting to pull data from Labor Rates into Schedules. Right now Schedules is the Parent Table, with a Summary Field towards that specific fid label name.

        ------------------------------
        Alex Bennett
        ------------------------------