column totals - how to

Submitted by jan_rifkinson on 2012/01/05 15:24
I read several articles from the online help file but don't understand a few things.
Here's my grid
 
It appears the children part of the column equation isn't implemented yet.
putting that aside
 
I gathered a year's worth of these expenses which I want to put into a year end report
 
Do I put a column equation in the BDIxpnsCost field?
 
 
If not then where?
 
What I do in this case where the BDIxpnse are all children?
Suppose they weren't, would my equation be children = sum
where would the total appear or do I have to create an item = Total
I can't picture this process.

Deleting many items in W5

Submitted by Jon on 2012/01/05 13:31
This thread deviated and I began to address an observation about deleting items in W5. From my post:
 
 
Deleting large numbers of items (approximately 100 with sub items for most) works, but the cursor never returns to normal. It always shows that it is busy. I can navigate to other grids, but the cursor does not return to normal. After the items are deleted, IQ shows normal CPU usage. This does not occur with W3.

Jon 

Duplicate grid bug?

Submitted by Jon on 2012/01/04 14:16
Maybe I am not understanding this. I need to create a duplicate of an existing grid, but I need the grid to hold fresh data. In other words, it has to be blank. Now I realize that duplicating a grid really just creates a copy of an existing grid with a different name. The source is the same as the original, so it shows all the data contained in the original. Deleting any data in the copy also deletes it from the original. So far, so good.
 
When I go to Manage Grids and try to change the source, shouldn't I see the name of the duplicate? If I have a grid called 2011 and duplicate it with the name 2012, shouldn't 2012 become available as a field? When I tried to create a field called 2012, IQ reported that this field already existed. If it does, I cannot find it.
 
This does not seem to be consistent with creating a new  grid. When I do that, a corresponding field is created.
 
Jon

Problems using number column as tree column

Submitted by Jon on 2012/01/03 15:01
 I set the number column as a tree column. In doing so, I lose the following functionality:
 
1. Enter no longer creates a new item It is checked in Options, and it does work if Item is the tree column.
2. After creating a new item, I cannot begin to type in it as before (when Item is the tree column). Auto search is disabled, and it does work for me if I re-enable Item as the tree column.
 
Jon