This content has been marked as final. Show 5 replies
I have a measures like below all the result showing in seconds I want to display as hr's I tried below but not getting the exact result
2) =if(ElapsedTime>=Urgent and ElapsedTime<=Critical,ElapsedTime-Urgent,Null())
3)=if(ElapsedTime>=Normal and ElapsedTime<=Urgent,ElapsedTime-Normal,null())
I tried like //=num(floor( (ElapsedTime-[Critical])/3600,'##.##') how to get exact format like only I need 1139,1139,783, like in all 3 expresions how to include?
it is showing