Skip to main content
Question

Formula field using a lookup field from a parent table is not populating properly

  • August 8, 2019
  • 0 replies
  • 37 views
Parent 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?
    This topic has been closed for replies.

    Is it possible you have a circular formula? Similar to excel where it�s not possible to calculate the result properly. As the formula field refers to itself indirectly?
    • MattHartman
    • Author
    • Registered
    • August 9, 2019
    That's what it is- thank you!


    • MattHartman
    • Author
    • Registered
    • August 9, 2019
    What 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.
    Terms & ConditionsAccessibility statement