InfoQube IM - Community

Submitted by Armando on 2010/02/11 01:05

Version 0.9.25Pre-Rel18

I haven't done extensive testing, but from what I've seen, Hierarchical equations have priority over row equations. Am I wrong ?

This is fine in most cases, except when sub items are non existent or don't meet the hierarchical equation's conditions (i.e. : the user uses some conditions in the hierarc.equation to filter items out from the equation) . When sub items are non existent or don't meet the hierarchical equation condition, the result will always be null, and recalc will never always result as a null -- at least, that's what seems to happen here.

Could this be changed so that when there are no items available to calculate the equation/function, row equations have priority ?

I haven't thought of all the implications of such a change though... (But thought of suggesting before I forget.... since it's time to sleep...)

Comments

Hi Pierre -- this is an important issue for me as there aren't any ways at the moment to do a recalc at the moment if there are some row equations (unless one does a full recalc... Not very convenient). And moving sub items away, will always produce the same result in the parent, whether there is a row calculation or not : null

1- create a new DB, with sample content.

2- open the to-do's grid

3- modify the urgency field so that the hierarchy calculation corresponds to " parents = max ((children)) "

4- Back to the To-do's grid : perform a recalc (shift F9) on any urgency field/cell.

It becomes null

Mantis : 891

This one is hard to deal with at the moment -- just telling as I haven't got too much feed back lately.

Recalculation for the incriminated fields involves one of these (every time the result become null -- see first post):

1) whole DB calculation .

2) Deleting data of the other fields involved in the row equation, and entering them again.

...

I see what is the cause of the problem. The row calc computes correctly, then the column calc starts and calculates the max of the children, but there are no children, so it becomes null.

I may need to address this more globally, but for the moment, I won't erase values if an item has not children

[quote=Pierre_Admin]

I see what is the cause of the problem. The row calc computes correctly, then the column calc starts and calculates the max of the children, but there are no children, so it becomes null.

I may need to address this more globally, but for the moment, I won't erase values if an item has not children

[/quote]

Yes, that's it.

And this solution should do it.

Thanks.

Hi Pierre,

This one is high priority bug for me too.

It is not completely fixed (Version 0.9.25Pre-Rel18A build 2010-02-26 22:45:32 Beta).

As we talked about :

1- when there's a hierarchical calculation + a row equation in an field

2- when performing a recalc on this field in an item with children, results become "0" (whatever the amount of children)

It's incredibly easy to do mistakes and calculation problems.

Thanks.

[EDIT : this should be put into the bug section]

[2010 03 08 : moved this to the bug section -- just realised I could do that...]

This is fixed in the next release

Thanks !

[quote=Pierre_Admin]

This is fixed in the next release

Thanks !

[/quote]

Thanks.