Column Total using Sum Variable gives last record in the set not the Sum

[barney12345]

So am a newbie to jaspersoft and have searched the community for an answer to this and found some help but none of which solved my issue.

 

I have an istudio 5.6.1 report than collects various fileds, runs some expressions and i want to sum the final column.  BUT i get the final record in the dataset not the Sum of the column. I have tried changing the Eval time on the expression  and the reset type on the variable but nada.

 

I think its a problem with my expression in column Nav* Shares in Issue *NAV% 

PRODUCT($F{public_history_stocks.premdisc%},new Double($F{public_history_stocks.navtimessii}.doubleValue() == 0 ? 0 : ($F{public_history_stocks.navtimessii}.doubleValue()/$V{public_history_stocks.navtimessii1}.doubleValue()))*1)

I think its cos of the double value but when i change to int or bigdec it throws errors

so the above code is in text field and there is a variable with the same code set to sum in the summary band.

 

I can proviode the code but its quite long

 

 

<