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. Fo...
Formulas and functions
Relationships
Tables and fields
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.