Creating calculated truncated Age field in Ad Hoc View

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?


laura_4's picture
Joined: Oct 18 2017 - 2:04pm
Last seen: 5 years 11 months ago

0 Answers:

No answers yet