Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
seria isso que está procurando?
se não for, poste o arquivo para melhor entendimento!
didn't work...
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.
AFAIK Sum function doesn't work with column as it expects real expression. See if this sample can help.