Hi ,
May i know that below expression is ok?. Because I used set analysis expression for workhour and travelhour and simple if condition for ContractedTime.
(Sum({< Audit_Date = {"<=$(#vDateTo)>=$(#vDateFrom)"}> } WorkHour)+Sum({< Audit_Date = {"<=$(#vDateTo)>=$(#vDateFrom)"}> } TravelHour))
/
(sum( if(Start_Time_Date >=Date_Master_From and Finish_Time_Date<=Date_Master_To,Contracted_Time)))
Can we use set analysis and if condition in one expression as above. Any suggestion appreciated.
