Hi Team,
I have a couple of simple tables, Table A and Table B, with a 1M relationship.
Table A has some rollup fields which roll up some formula fields on table B.
I have noticed that the rollup fields in table A do not update when a record is created in table B (presumably it tries to update the rollup before the formula on table B has calculated). Creating a second record in table B triggers the rollup in table A to re-calculate but it only gets the figures from the first record in table B.
Effectively, Table A always has incorrect figures as it never calculates the values from the newest record in Table B.