[Solved] Aggregation SUM with conditon

[neozerabbit]

For a sub report I have for exemple

GlobalView        Total                                     typeA                                                               type B

Commission     sum(commissions)         sum(commissions of type==typeA)           sum(commissions of type==typeB)

Fees                     ...........

 

I only use the page footer to display my data after everythinh has been processed.

Total is quite easy I only have to set a sum of my "commission" filed on the page. But for "typeA" & "typeB" I do not know how I can filter data (i made some try with if condition).

 

Anthony

Post Edited by neozerabbit at 01/13/2011 09:09

[ceday]

 sum expression for COMMISSIONA=> $F{TYPE}.equals("A") ? $F{COMMISSION} : new BigDecimal(0)

[neozerabbit]

Thank you. I realize my mistake was on the if expression.

I set    .... == "typeA"  instead of .....equals(...) in my sum variable