Discussions

 View Only
  • 1.  Formula field using a lookup field from a parent table is not populating properly

    Posted 08-08-2019 06:16
    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?


  • 2.  RE: Formula field using a lookup field from a parent table is not populating properly

    Posted 08-08-2019 12:32
    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?


  • 3.  RE: Formula field using a lookup field from a parent table is not populating properly

    Posted 08-10-2019 07:12
    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.


  • 4.  RE: Formula field using a lookup field from a parent table is not populating properly

    Posted 08-08-2019 21:09
    That's what it is- thank you!




  • 5.  RE: Formula field using a lookup field from a parent table is not populating properly

    Posted 08-08-2019 21:30
    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.