Help with formulas
i need a formula that uses the (total of field a) minus (field b) instead of (field a) - (field b) which quick base only allows me to do, but when i view my table it shows a total. i need this set up ...
Forum Discussion
Excellent, and let me know if you have any further questions. These summary calculations can be a little tricky to set up when you are first learning them but can be very helpful.
- Now that you mention it.... I am struggling to set up the relationship in a way that gives the correct figures. At the moment, once I have the summary field set up the column stays empty and I can't relate this figure onto my other table. Any tips on how to set this up correctly? If it helps, I am trying to relate a total figure from one table onto another table grouped by names. Thank you!
- Usually if the summary field isn't populating with values for a record that means those records aren't related yet. When you look at the related fields do the parent records have child records related to them? If this is a newly created record you would need to make sure to assign the child records to the right parent records.
- How do you add child records? Thank you!
- Hi Demi,
You would want to go into your existing child records in your table that you are summarizing up from and edit them to make sure each child record has a Parent Assigned. You can figure out what field this is by looking at your relationship between the Parent and Child table, it will list the reference field for that relationship which has to be filled in for the relationship to function. If you are having issues with this I would suggest putting in a support case so that you and a rep can look at your relationship and records together as there might be some disconnect that is causing the issues you are running into. You can create a new case in Quick Base if you click Help in the upper right hand corner of the page when signed into Quick Base > Manage Support Cases > + New Support Case. If you are still having issues getting Parent and Child records to sync up they can help look at the relationship with you and identify what is causing those summary fields not to bring up your data.
