ROUND, FLOOR, CEILING <-- No calculations possible after using these funct
Hi All,
Im currently working with calculated fields in Oracle BAM(11.1.1.3.0 build 8533) where I encounter the following problem:
After using FLOOR, ROUND OR CEILING I cannot make any calculations.
My code is as following: (CEILING(((Now()- UitvoeringEindtijd)/86400))) / (7)
without the / (7) it works fine.
To make the problem easier and more clear I have tried: ROUND(2.9765, 2) / 3
Also this fails with error: BAM-01242: Invalid calculated column: collumn name
I have tried nesting the value in an other column and returning it in the code in an other calculated cloumn. This gives a succesfull compilation but when I try to look at the content I get the following error: BAM-01611: Math expression contains a non-numeric operand.
My current thought is that the 3 respective functions do not return as an integer, or any other nummeric value.
I would like to know if it is posible to solve this issue, am I doing something wrong? Or is the BAM server not correctly handling these 3 functions?
Best regards,
Martijn van der Kamp
Edited by: 841128 on Mar 2, 2011 8:03 AM
Edited by: 841128 on Mar 2, 2011 8:07 AM