1 Reply Latest reply: Jul 9, 2012 6:24 AM by Jonathan Dienst

how to bring a calculated field column total into next column ???

Dear All

how to bring a calculated field column total into next column ???

for example

 Column 1 Column 2 Column 3 Total 3,735.32 3,735.32 01/07/2012 461.60 3,735.32 02/07/2012 889.08 3,735.32 03/07/2012 621.45 3,735.32 04/07/2012 12.76 3,735.32 05/07/2012 623.03 3,735.32 06/07/2012 673.71 3,735.32 07/07/2012 350.21 3,735.32 08/07/2012 103.49 3,735.32

column 2 is a calculated field the total value 3735.32

column 2 total should be come into column 3 as 3735.32, is it possible ???

• Re: how to bring a calculated field column total into next column ???

Hi

No, it do not believe that it is possible to read the total value from one column. You can recalculate the total by using an Aggr expression:

=Sum(Aggr(...the expression for column1..., ...table dimension(s)...))

Just place the column 1 expression and dimensions in the expression as shown.

Hope that helps

Jonathan