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 02, 2013 9:28 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Today @ 5:59 PM Points: 571, Visits: 3,730
 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 02, 2013 9:29 PM
 Mr or Mrs. 500 Group: General Forum Members Last Login: Today @ 5:59 PM Points: 571, Visits: 3,730
 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