### Title

Division by sum

### Post

Is it possible to divide the sum of a field by 2?

How do i write the calculation for that?

Would appreciate the help on how to do that?

Division by sum

Is it possible to divide the sum of a field by 2?

How do i write the calculation for that?

Would appreciate the help on how to do that?

But what fields are you adding? Not that it matters, really - but there's clearly more to this than simply "how do I divide a number by 2?". Whatever you were going to tell me was how you sum the numbers, I was expecting to suggest you just divide it by two. The sum function works two ways. If you have some number fields in the record it can add them together:

Sum ( Field1 ; Field2 ; Field3 )

If you want to add the values in a number field in every related record, you can use:

Sum ( Relationship::NumberField )

In both those examples just dividing that by 2 will give you the answer.

Here is a quick screen print showing my example. In my example each record is a family, with the State they are in and number of kids. Then I create NumKids.sum (my notation indicating the summary field of NumKids. Use the Summary field in Subsummary parts of a layout, when creating a report. For my example sort of State. DispSumm is a calculation field to do math on Summary Field. Hopefully this helps.

What do you mean by the 'sum of a field'?