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 <