0.9.25W3 fixed two key hierarchy equations issues as described in [FIXED] Bugs with conditional column equations (important...), but it didn't fix this third issue.
I originally thought it was boolean related, but it seems to be a general problem of hierarchy equation not being triggered when a child's value is deleted.
To reproduce:
- open sample db
- go to TranscriptStats tab
- select and delete a CourseGPA value for one of the items
- the parent does not recompute (it should)
- select the parent field and do shift-F9, the correct value is shown
It's worth noting that for booleans unchecking is the same as deleting (I think). So this is much more visible with booleans.
Thanks,
dave
Comments
Here are the 3 problems I'm aware of in relation to column equations (conditional or not -- but I mostly tested them with conditional equations):
----> impossible to manually recalc a column if there's a simultaneous
columnROW equation : total always = row equation result. (Shouldn't be. Column should always have priority over row -- well in 99% of cases...)-----> when a subitem is removed from the parent (deleted or simply removed), calculation isn't re-performed (so, it stays unchanged)
-----> + the one you mentioned (David) : "The parent is updated when one child value is deleted, but it is not updated when the last child value is deleted." (by "last child value", David means the last remaining one).
(Edited 2012 07 07 : few language mistakes)
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 3
Dell Vostro 1500, Ram:3gb, CPU: Intel Core2Duo T7500 2.2ghz