Calculating Averages in a cell outside of a table

building reports desktopintelligence
1

I have a simple problem. I am trying to calculate the average of a numeric column, but I want to display it outside the report in a cell. If I drag it out of the report and try to put in the cell it calculates the sum. I have tried all the various functions, but not been able to find an answer.

Thanks

[edited title, removed urgent - Andreas]

AA :us: (BOB member since 2004-02-28)

2

Hi

You can try this out.
Apply Average on the column.
Copy the whole table (by dragging with the crtl key pressed).
Format the copied table and check the FOLD option, uncheck the TABLE HEADER option.

This would resolve the problem.

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

3

Another thing you can do is in the designer, select “Average” as the aggregate function for that object.

Once you do that, it will show the average no matter where you drag it to.

kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

4

Thanks Kashif…

I will try the solutions…

AA :us: (BOB member since 2004-02-28)

5

The DEsigner solution worked…

thanks

AA :us: (BOB member since 2004-02-28)

6

Please do NOT put Subjects like this on this board. Please make the subject meaningful.

Steve Krandel :us: (BOB member since 2002-06-25)