I have added below script in the backend and naming it as WorkingHours...This is excluding weekend and calculating hours accordingly.
NetWorkDays(DT1+1,DT2-1) * 1
,if(NetWorkDays(DT1,DT1) and floor(DT1)=floor(DT2),-1 ) )))as 'WorkingHours',
Works well for some dates. Working hours col has been taken as dim just to present the correct nos. These nos should reflect in working hours(expression) column ideally. Using ='WorkingHours' on the straight table as an expression. See below : Would really appreciate, if someone can help me out get the nos correct. Thanks
|Working Hours (dimension)||Working Hours(expression)||Value||weighted||final||Correct Hrs|