Skip to Content
Former Member
Mar 31, 2006 at 08:07 PM

Cell definition



I have two structures in my query. One on the rows and the other in columns. The row and the column structures both have a formula, Average. Now I want to define an exception formula at the point of intersection of these two formulas, hence cell definition. My formula is very simple, it would add up the total along the rows for column1 and then divide it by a total in column 2. But I cannot find the individual elements in the structures in the formula editor in cell definition.

I hope I am being clear.

Please help.

Ashmith Roy