Sum Total Column()

[Anonymous]

Hi All,

It is possible to sum a column()?

For example:

Column(1) - is equal to  =Column(2) + Column(3)

With column(4) , I want to sum total column(1) * percentage.

I tried with =Sum(Total column(1)) * Percentage, this didn't work.

Many Thanks,

Frank

[#2]

seria isso que está procurando?

se não for, poste o arquivo para melhor entendimento!

[Anonymous]

didn't work...

[Anonymous]

Hi, not sure what you are trying to do, but why not something like?

column 4 = (sum([Field_Column_2]) +  sum([Field_Column_3])) * percentage

If what you need is the fixed total from column 1, could also store the total sum from Column2 and Column3 into a variable and then multiply that by the percentage field to get column4.

[Digvijay_Singh]

AFAIK Sum function doesn't work with column as it expects real expression. See if this sample can help.