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

Question

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------------------------------

markshnier__you · Answer

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 · Answer

Nope isn't blank------------------------------Alex Bennett------------------------------

markshnier__you · Answer

Is the relationship setup properly?&nbsp; Do parents have child records that you can see on the parent record?&nbsp; Do children have lookup fields to "prove" that they are children of the parent records?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

alexbennett3 · Answer

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------------------------------

markshnier__you · Answer

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)].&nbsp;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.htmlThe 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

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

Related Content

Display Thumbnail Image

Summary Reports

New Form Button display settings

Maximum Summary field not working

Form rule modal display a link