[By the way, Pierre, this is really great! Can't say enough about the power of this program.]
CourseUnits hierarchy operations: Parent=sum(children)
My hierarchy operations are not working. in the box, I'm only supposed to input "sum" right? because the "((children))" automatically appears on the right when I choose "parent" from the drop-down. Similarly, none of my equations for fields are calculating. They are all blank in the grid, even after I close/reopen the grids. How do I "activate" these calculations?
Also, for the last line of your code, I modified it to be:
if isnull(Grade) or grade="" or grade="P" then CalcGPA=null
so it can ignore classes with P for passing.
Another point I wanted to make is about sorting, I think I've mentioned this before. Sometimes, especially in cases like this transcript, things are ordered and sorted in a random way (ie not alphabetically or numerically). If I accidentally click on one of the columns and it adjusts the sorting, I lose the sorting I had before. How can I save a random sort to retrieve it later?