Formula Help
I need help putting a formula together where i would like to divide a given number by the number of details. Can anyone help me find this function / formula? Thanks,
Forum Discussion
Are you saying that you have a Parent record and it has a child table in a relationship called details?
If so you can make a summary field on the left side of the relationship to count the # of Details. You might chose to call it
# of Details
Then the formula numeric field on the on the parent record would be
[My Given Number field] / [# of Details]
and set the decimals to display as say 0 or 1.
If so you can make a summary field on the left side of the relationship to count the # of Details. You might chose to call it
# of Details
Then the formula numeric field on the on the parent record would be
[My Given Number field] / [# of Details]
and set the decimals to display as say 0 or 1.