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
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.
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…
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