3 Replies Latest reply on Feb 19, 2016 11:10 AM by Rody Zakovich

# Is it possible to use a calculated field as grand total?

I would like to use a calculate field as a Grand Total.

Exemple:

Column 1        Column 2

A                     100

B                     40

Total               (100/40)

• ###### 1. Re: Is it possible to use a calculated field as grand total?

Possibly  - see Jonathan Drummey's write up here:Customizing Grand Totals – Part 2 | Drawing with Numbers

I'm guessing the fairly straight forward example above is not representative of the real data though.  Another possibility is to use the calculated field in a different view and align two views in a dashboard.  Jonathan describes this in the Part 1 of the series on that page.

Patrick

• ###### 2. Re: Is it possible to use a calculated field as grand total?

I do that in a bunch of places.  (I use ... IF FIRST()=LAST() then [calc field]... to identify the total row.  But it's the same principle.)

So roughly, the sort of calc field I would use to display what is in the initial post would look like this:

IF FIRST()=LAST() then [calc field] else

sum([column2-data-field])

end

And [Calc field] would be whatever calc is needed to be displayed in the grand total cell.

• ###### 3. Re: Is it possible to use a calculated field as grand total?

Hello Biance,

Quick question, because it could change the scope of how this is done.

Do you want to the Grand Total to be a String? I.e. it would literally show '(100/40)'?

Regards,

Rody