I have limited access to Jaspersoft Ad Hoc views and am trying to create a calculated Age field. The field currently contains 2 decimal places. I would like it to be truncated to 0 decimal places but do not see a TRUNC function. There's a ROUND function, but that rounds the age up.
Is there a way to do this in the Ad Hoc View create calculated field window?
0 Answers:
No answers yet
