Why is my Summary field showing different values based on location in form?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
My summary field is showing me different values based on its location on a form?


Am I going crazy or has someone else seen this before?
Photo of William

William

  • 162 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ricardo Tsai

Ricardo Tsai

  • 40 Points
Hello William,

Can you share more information about the relationships and the criteria used in the summary fields?

Ric
Photo of William

William

  • 162 Points 100 badge 2x thumb
Hello Ric,

This is a many to many relationship between Parts a Bill Of Materials. Bill of materials have related parent parts and related child parts. The parent parts get their cost from the sum of all the child parts cost. Parts without child Bill of Materials have their cost entered into a currency field.

Line Item Total is equal to Quantity Required * Child part Cost.

As exmplained by Quickbase, the relationship is a resursive one, and can give unpredictable result.

Changing the Order of Operations seemed to fix this, although I am not sure why.
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
You need to make sure that the Key fields that control the relationships are not summaries based on a previous relationship