Jump to content
Changes to the Jaspersoft community edition download ×

Creating calculated truncated Age field in Ad Hoc View


laura_4

Recommended Posts

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?

 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...