making sum of percent column

[s9202]

I have made table with one column of numbers and another of percent values.

Percent values are made by textFields with expresions like this: <textFieldExpression><![CDATA[new Double( ($F{number}.doubleValue() / $V{totalNumber}.doubleValue())*100 )]]></textFieldExpression>

In column footers i want to have totals. For number is ok, but i have no idea how to make it for percent values, because they are only a textFields.

Number || Percent

4     ||     40%

3     ||     30%

3     ||     30%

==Totals===

10     ||  100% <-- problem

[ravenheart]

Why not store or create the % values as decimals? 0.3, 0.4 etc.? Then they'd sum correctly, and all you'd need to do in the report is set the display pattern to be a percentage.

[s9202]

As you see this value is Double (look in my expression).

My problem is that I know how to sum Fields from datasource like my "Number" column, but I don't know how to sum simple textFields which counts % values for me in "Percent" column.

[ravenheart]

So you're percentages aren't stored in a field in the data source? You're creating them in the report for each value from the number field?

[s9202]

Yes, that's right. I get "Number" from datasource and then my report counts % in Percent column.