Recent PostsRecent Posts Popular TopicsPopular Topics
 Home Search Members Calendar Who's On

 Creating % based on total of rows Rate Topic Display Mode Topic Options
Author
 Message
 Posted Wednesday, November 20, 2013 9:43 AM
 Forum Newbie Group: General Forum Members Last Login: Wednesday, December 11, 2013 2:56 AM Points: 1, Visits: 5
 HiI 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=1PredTime=4I 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
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 7:06 AM Points: 2,135, Visits: 12,280
 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 report4. 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
 SSCrazy Group: General Forum Members Last Login: Yesterday @ 7:06 AM Points: 2,135, Visits: 12,280
 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 report4. 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

 Permissions