Discussions

Expand all | Collapse all

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

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

    Posted 30 days ago
    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 through the steps to do so, I add the Summary Field to the form sections needed, but nothing displays. I've heard maybe I can't do this with Currency fields? Wondering if anyone has any solutions, or maybe any options I can do to complete this task!

    Any help would be appreciated!

    Thanks,
    Alex

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


  • 2.  RE: Summary field won't display, average of hourly wage(currency)

    Posted 29 days 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
    ------------------------------



  • 3.  RE: Summary field won't display, average of hourly wage(currency)

    Posted 29 days ago
    Nope isn't blank

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



  • 4.  RE: Summary field won't display, average of hourly wage(currency)

    Posted 29 days 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
    ------------------------------



  • 5.  RE: Summary field won't display, average of hourly wage(currency)

    Posted 27 days 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
    ------------------------------



  • 6.  RE: Summary field won't display, average of hourly wage(currency)

    Posted 27 days ago
    OK, yes this sounds backwards.

    I think that you should delete that relationship because it seems to be what makes sense is that you have a master table of labour rates and then those rates are pulled into the labour schedules which presumably is where you are scheduling staff to go out and do jobs. So you will want to have just a simple look up for the labour rate and what I suggest you do is label that lookup field as [Labour Rate (lookup)]. 

    And then you will make a field calle Laboir rate and it will be a snapsho o the loopk up fieldf https://help.quickbase.com/user-assistance/setting_up_snapshot_fields.html

    The reason for that is that in six months or a year when you adjust the labour rate, you do not want your historical scheduled jobs from the past suddenly change their rate.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: Summary field won't display, average of hourly wage(currency)

    Posted 27 days ago
    Ok I will give that a shot! Thanks Mark! I appreciate your help!

    Thanks,
    Alex

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