Hi, I have 3 tables: Item, Item Amount, Sales Order. The relationships among the tables are:
- Item : Item Amount is 1:N
- Item Amount : Sales Order is N:1
There is a field Item in Item Amount that lookups to Item table, and another field Order that lookups to the Sales Order table.
For each order, there are multiple item amounts within the order. I have a calculated field Item Total in Item Amount table as ItemAmount.Quantity * Item.Cost (referencing a different field from the relationship between Item and Item Amount).
I want to create a rollup field Order Total in the Sales Order table that sums up the different Item Total from Item Amount table, but the Item Total field would not show up in the Aggregated Related Entity Field (I have tested with a regular calculated field in Item Amount that does not fetch referential fields from the Item table and it would still appear).
My current guess is that Aggregated Related Entity Field would not fetch calculated fields that reference another table?
