Customer is using Elasped* functions for calculated measures in Ad Hoc Designer. The problem is the result. It is returning decimal with fraction. Change format yields incorrect values due to rounding [e.g. 2.5 days gets rounded to 3 days]. Apparently, based on previous sales force cases, this behavior does not seem to be changable. Customer is asking for additional functions such as modulo() and trunc() to get around this issue.
Issue environment: JS v7.2.0 bundled Tomcat/postgresql on Windows.
Jasper Product + version:
App server + version:
DB + version:
JVM version:
Operating system + version:
Browser + version:
Steps to reproduce:
1. Try anyone of these functions in Ad Hoc designer: ElapsedDays/Hours/Minutes/Seconds() functions
2.
3.
Expected result: Correct whole number
Actual result: Fractions
Components | AdHoc |