i want to make a calculation between to numeric fields by using a request type rule. But the system can only handle integer values. But if i try to calculate floating point values, i get the error message (see attachment).
How can i calculate floating point values in PPM?
Did u try usin comma instead of point. Perhaps regional settings are wrong.
Did you ever get this resolved? We're on 8.01 and we don't have an issue with this rule SQL...
select nvl('1.1','0')+nvl('1.2','0'),nvl('1.1','0')+nvl('1.2','0') from dual
select nvl('[REQ.P.P_ROM_ESTIMATE]',0) - nvl('[REQ.P.P_PLANNING_ESTIMATE]',0),nvl('[REQ.P.P_ROM_ESTIMATE]',0) - nvl('[REQ.P.P_PLANNING_ESTIMATE]',0) from dual
Looks like you had some SQL queries commented out