Forum Discussion

MattHartman's avatar
MattHartman
Qrew Trainee
6 years ago

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

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?
Formulas and functions
Relationships
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    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's avatar
      MattHartman
      Qrew Trainee
      6 years ago
      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.
  • MattHartman's avatar
    MattHartman
    Qrew Trainee
    6 years ago
    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.