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
1 Answer:
Posted on April 2, 2018 at 4:45pm
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...
