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
Vinish Kapoor
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:
Swarup
((replace(:P6_LOGM, ':', '.')+replace(:P6_LOGT, ':', '.')+
replace(:P6_LOGW, ':', '.')+replace(:P6_LOGTH, ':', '.')+
replace(:P6_LOGF, ':', '.')).30 * 100 / 60 = .50)
is it or another way
Vinish Kapoor
You just use the below for now:
Swarup
please guide be sir about that time
Vinish Kapoor
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.
Swarup
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
Swarup
please guide me sir please...
Swarup
please guide me where to implement in which steps
Swarup
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