The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

error in calculation between numeric fields

Highlighted
Sascha_1
Member

error in calculation between numeric fields

Hi,

 

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?

 

Regards,

Sascha

 

2 REPLIES
sebastianrm
Super Collector

Re: error in calculation between numeric fields

Hi,

Did u try usin comma instead of point. Perhaps regional settings are wrong.

Regards,

 

S

 

Cat_2
Regular Collector

Re: error in calculation between numeric fields

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

 

or

 

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

//Add this to "OnDomLoad" event