Build domain / AdHoc-Views with ceiling function

0

hi,

I just want to use the ceiling function, so that I get always the next whole number of  a fied.

When I use it in the calculated field in the domain, I can use it an don‘t get a error-message, but I can‘t use this field in the adhoc view => there I get an error message

In the Adhoc-view itself there is no support for ceil-function, right?

I only found the round function, but that not what I‘m searching for.

can anybody help me?

bye

 

p.hildebrandt's picture
Joined: Feb 7 2018 - 2:11am
Last seen: 1 year 7 months ago

1 Answer:

0

You may want to create a custom function. Here is a link to a community article that goes into some detail about this:

https://community.jaspersoft.com/wiki/creating-custom-sql-functions-doma...

Friendly User's picture
Joined: Oct 8 2009 - 5:59am
Last seen: 2 days 1 hour ago
Feedback
randomness