how to create a field percent formula with a sum value.

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
Currently have a scrap % field using scrap pcs/pcs produced. I am trying to use a scrap % of a given time period using the sum of scrap pcs over that period of time/ the sum of pcs produced over that period of time. Can anyone help with this?
Photo of Stephen Lambright

Stephen Lambright

  • 80 Points 75 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,904 Points 50k badge 2x thumb
You will need to create a new table to accumulate the totals.  For example load up a table of dates with the first day of each month and make that the Key field of the table.  Then make a formula field to calculate the first of the month and use that field to connect to the summary table. Then make your your totals in the relationship and do the calculations there.

But if you have complex breakdowns by product, for example, then there is not an easy way to do that.
Photo of Stephen Lambright

Stephen Lambright

  • 80 Points 75 badge 2x thumb
It is a complex breakdown of a large number of different parts. I have individual scrap % as this is easy.


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 69,904 Points 50k badge 2x thumb
There is no automatic easy way just to divide those two numbers.

In a single user environment You could set up a single record in a single table where the record id is 1.

Then you could relate that table to every record in your details table through a relationship where the reference field is a 1 as well.

Then you would have any filters on that single record such is some date boundaries and then summarize your columns on that report up to that record ID number one. And you would be able to do your calculation there. That would give you some flexibility in the filters on the report and give you your totals.

This could also be extended to a multi use your environment just so people are tripping over each other when they are editing that filter record ID number one