I have a situation where I have a two-tab report. I need to use a
calculation created from the second query in a calculation in the table
created from the first query. Basically, I calculate a single weighted
average from a table and want to subtract that average from each row in
another table. I have created a variable for this weighted average, but
when I attempt to insert it into a new column on the first table, all
the rows but one telescope into one row for the weighted average.
I think it is a problem of context in each tab. You probably don’t have the
same context of calculation in each tab, so the results appear
disappointing.
Maybe you can describe us more in details your reports.
Listserv Archives (BOB member since 2002-06-25)