ContributionsMost RecentMost LikesSolutionsRe: Formula field not populating for some recordsI think you're right. Thank you. I started fixing some of the nulls with IF statements in formula fields containing other fields with zeros that resulted in Null results, but there are zeros and resulting nulls in various fields so it's getting complicated! I think I will continue to troubleshoot that and come back on if it doesn't work out. Thanks again. ------------------------------ Matt Hartman ------------------------------ Formula field not populating for some recordsI have a formula field that subtracts one other formula field: "Company 1 Total Fees" - "Company 2 Total Fees" to get "Company 2 Savings" Both "Total Fees" fields are formula fields and have several other fields calculated within the record. For some reason, only about 2% of the "Company 2 Savings" fields have values even though all "Total Fees" fields are populated. Can't figure out why this is happening. Anyone have an idea? Thank you! ------------------------------ Matt Hartman ------------------------------ Re: Formula field using a lookup field from a parent table is not populating properlyWhat would be the best way to have a commission percentage populate based on a running total of their sales production for that year? Essentially, once they've earned a certain dollar amount for the year, their commission percentage goes up for subsequent sales they make the remainder of the year. Re: Formula field using a lookup field from a parent table is not populating properlyWhat would be the best way to have a commission percentage populate based on a running total of their sales production for that year? Essentially, once they've earned a certain dollar amount for the year, their commission percentage goes up for subsequent sales they make the remainder of the year.Re: Formula field using a lookup field from a parent table is not populating properlyThat's what it is- thank you! Formula field using a lookup field from a parent table is not populating properlyParent table has a numeric formula field (percent) (A) with an IF statement formula. Child table contains a lookup of this field (B). Child table has another field (C) that uses (B) in the formula. For some reason, when you first create a record or edit a record in the child table, field (C) is populated. However, it disappears when accessing that record again. If you click edit and save again, it populates again. Any ideas why this is happening? Tables comparing goals with actuals using a count mechanism.Hi All. I have a table in which each record represents a real estate transaction and I have two "Types" of transactions (Seller and Buyer) and various "Sources" of business (open house, referral, farm, etc). I have another table that has the goal for each real estate agent- number of each "Type" (seller or buyer) by each "Source". Thus I want another table to compare their actual results (the transaction table) and their goals (goal table). I figure I need a way to have summary fields that count the type and source of each transaction but don't know the best way to achieve that. In the goal table, the source and type are represented such as Sellers - Open House =2 , Buyers - Open House = 1 and so on for every combination of type and source. So I'd like to have identical fields that are for actual results that reference the transaction table and count baed on the values in the Type and Source fields. Any help would be greatly appreciated!