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%
Column Total using Sum Variable gives last record in the set not the Sum
in Products
Posted
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