how to calculate Totalsum of percentage in ireport

[anupp]

Hi,

    I have done percentage in ireport  for each column.but i m facing problem is how to calculate sum of percentage in ireport.for example :

row1 -10%

row2-90%

sum of  Total percenatge is 100%.(i want to do that calculation only.)

 

Thanks

Anup

[despec]

Hello,

 

This is something I jotted down when I needed to do something similar to what you're doing. Perhaps this will help you find your answer as well:

 

 

Calculating a Percent Using a Report Total

 

-- First, define a variable that sums a field in your table. Set the "Reset Type" to REPORT and the "Increment Type" to NONE.

 

-- Now add a text field to the detail line to calculate the percentage. Set the "Evaluation Time" to AUTO. Create the expression, for example:

 

new java.math.BigDecimal($F{AP_PAYMENT_COUNT_TOT}.doubleValue() /

$V{ap_payment_count_rpt_tot}.doubleValue())

 

-- With the evaluation time set to auto, the field value is NOW and the variable value is REPORT to allow for the right calculation.

 

 

 

David

[anupp1983]

Hi,

each row percentage calculate is fine but i want to TotalSumPercentage in footer Area.so plz help me how to calculate Total% in footer area?

 

Thanks

Anup