4 Replies Latest reply on Sep 12, 2013 11:11 AM by Drew Friestedt

# Table Calculation Issue - Total Table Down Showing Up on Row

I've created a custom table calculation to calculate the total of a single column in a table.  I want this to appear at the bottom of the column.

Table Calculation:

TOTAL ( SUM ([AUCTION_PRICE]))

The calculated amount is correct, I just want it to show at the bottom of the column NOT on the ROW.  See attached.

Any thoughts on how to move this to become a column total?

thx

• ###### 1. Re: Table Calculation Issue - Total Table Down Showing Up on Row

Does using the Grand Total functionality produce something that you don't expect. There are ways of customizing the total:

Customizing Grand Totals – Part 1 | Drawing with Numbers

• ###### 2. Re: Table Calculation Issue - Total Table Down Showing Up on Row

I'm actually trying to show a variety of column "results"

Column 1 = total

Column 2 = Average

Column 3 = Weighted Average of Column 4 & 5

I wanted to setup the simple Grant totals first and then go from there.  I did review your website which is great.

Column 1 I changed the calculation to :

IF FIRST()==0 THEN WINDOW_SUM(AVG([AUCTION_PRICE])) END

Column 3 (the weighted average column) I change to:

IF FIRST()==0 THEN WINDOW_SUM(AVG([NET PROFIT])) END / ( IF FIRST()==0 THEN WINDOW_SUM(AVG([AUCTION_PRICE])) END + IF FIRST()==0 THEN WINDOW_SUM(AVG([TOTAL DEVELOPMENT COSTS])) END)

New image attached.

• ###### 3. Re: Table Calculation Issue - Total Table Down Showing Up on Row

Not my site, Jonathan Drummey's.

• ###### 4. Re: Table Calculation Issue - Total Table Down Showing Up on Row

Now I get it...  I think this should solve my problem.