Monday, 15 July 2013

reporting services - Calculate Percentage Overtime in SSRS 2012 -



reporting services - Calculate Percentage Overtime in SSRS 2012 -

i trying create study calcualtes overtime has worked in week, understanding of calulation be.

my columns :

extra hours worked per week

total hr worked per week

calculation

extra hours worked per week / (extra hours worked per week + total hr worked per week) * 100

if represent columns minutes sum them , calculation 1 figure if sum minutes in hours , minutes , same calculation different figure. want know is, calculation right , if so, should doing calculation using minutes or using hours , minutes.

hope can help.

assuming want calculate percentage of hours, calculation should be:

((totalhours * 100)/(totalhours - extrahours))-100

and advise maintain calculation in minutes, , in end convert hours (and minutes).

ssrs-2008 reporting-services

No comments:

Post a Comment