Say you have an expression column which is an aggregate of child columns which are in turn aggregates of child columns. It appears to me that when you modify the lowest level values, the aggregates are recomputed one level up, but not two levels up. Is this the expected behaviour? I haven't been able to find anything on it in the docs, this list's archives, or google. A specific example, in case the above isn't clear. A dataset with three tables - companies, offices, employees. office rows are children of company rows, employees are children of office rows. employees have a sales column, a number. Offices have a sales column, an expression column which is the sum of the child employees sales. Companies have a sales column, an expression column which is the sum of the child office sales. Create an empty such dataset. Add a company, an office for the company and an employee for the office. Set the employee sales to 5. Then the office sales will be 5, but the company sales will be null. In general, the office sales respond to changes in employee sales as you'd expect, but company sales do not. If you reassign the expression value for company sales to itself at any point, it will recompute correctly. Interesting but not really helpful. This is 1.1, I haven't tried 2.0. Can anyone offer any insight or pointers to any place where this is discussed?
Thanks, Chris =================================== This list is hosted by DevelopMentor� http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
