Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating % based on total of rows Expand / Collapse
Author
Message
Posted Wednesday, November 20, 2013 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 2:56 AM
Points: 1, Visits: 5
Hi

I have a report that shows the time it took to do jobs as well as the time it was predicted the job would take. So...

ActualTime=1
PredTime=4

I want a gauge to show the % of jobs that were completed within their predicted time. Thing is, I can't work out the formula.

Can anyone help?

Olly
Post #1516119
Posted Monday, December 2, 2013 9:28 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:08 PM
Points: 889, Visits: 5,701
Kind of an old post, but this is how i did it.

1. Add a calculated field to the dataset.
2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)
3. Add a tablix to the report
4. 1st column: Actual, 2nd: Predicted, 3rd: OnTime (the calculated column)
5. Add a summary row, change the expression for the cell to:
=SUM(Fields!OnTime.Value)/COUNT(Fields!Actual.Value)
Post #1519060
Posted Monday, December 2, 2013 9:29 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:08 PM
Points: 889, Visits: 5,701
Kind of an old post, but this is how i did it.

1. Add a calculated field to the dataset.
2. Function: OnTime=IIf(Fields!Actual.Value<=Fields!Predicted.Value,1,0)
3. Add a tablix to the report
4. 1st column: Actual, 2nd: Predicted, 3rd: OnTime (the calculated column)
5. Add a summary row, change the expression for the cell to:
=SUM(Fields!OnTime.Value)/COUNT(Fields!Actual.Value)

Then just change the formatting of the cell in step 5 to Percent. Right-click, Textbox Properties > Number > Percentage > Decimal Places
Post #1519061
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse