Hi Sir,
i want to add fields,eg:there are 5 fields where if i enter 3 fields also the value should be calculated,and the number that i am entering is like 2:00,0:30 but i am unable to sum all the fields if i am entering like this able to do sum:2+3+5 using PLSQL Expression
(:P6_LOGM+:P6_LOGT+:P6_LOGW+:P6_LOGTH+:P6_LOGF)
unable to do sum 2:00+3:00+5:00
please guide me where to implement in which steps
Hi Sir,
Good Morning,where to declare this in Dynamic Section or Server side in individual fields and whether i need to assign any static id for this
This is the process i have applied
DA in Total_Hours
Event:Change
Action:Setvalue
Set Type:PLSQL Expression
Item To submit: P6_LOGM,:P6_LOGT …….
where to apply the above code
please guide me sir please…
It will not sum because the colon (:) is inside the string. Replace it with a decimal point. Try the following:
You may also need to tackle minutes specified after the decimal. For example, 2:30 + 2:30 should be 5 hours, not 4.60. Correct me if I am wrong.
To do this replace the value after the decimal point using the following formula:
((replace(:P6_LOGM, ‘:’, ‘.’)+replace(:P6_LOGT, ‘:’, ‘.’)+
replace(:P6_LOGW, ‘:’, ‘.’)+replace(:P6_LOGTH, ‘:’, ‘.’)+
replace(:P6_LOGF, ‘:’, ‘.’)).30 * 100 / 60 = .50)
is it or another way
You just use the below for now:
please guide be sir about that time
Extract the hours and minutes from the page items as below:
For example, if the user entered 2:30 for P6_LOGM, it will be converted to 2.50 in the variable. You will have to do this for every field.