Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert number to Percent?

Status
Not open for further replies.
AlreadyLost

AlreadyLost

MIS
Sep 16, 2005
191
US
What is the formula to convert a number to %.

My result display 180.33 but I actually want my result to the percent.

This is my formula to get 180.33:
(DistinctCount ({@TotalFacilityAssigned}, {@EmployeeFullName}))/3
 
Sort by date Sort by votes
This is something I did for timesheets
Code: 
{TimeRec.TaskTime}%Sum ({TimeRec.TaskTime})

The % is the actual command.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmck1964
  • Locked
  • Question
Using "OR" to select data
Replies
4
Views
586
mmck1964
mmck1964
jchewsmith
  • Locked
  • Question
Report filter to run report yeartodate through yesterday
Replies
0
Views
357
jchewsmith
jchewsmith
socalvelo
  • Locked
  • Question
Extract Phone Numbers from Text Field
Replies
0
Views
378
socalvelo
socalvelo
socalvelo
  • Locked
  • Question
Limiting the number of records in groups and sub-reports 1
Replies
2
Views
250
socalvelo
socalvelo
Brian S
  • Locked
  • Question
Splitting names that have variable numbers of spaces 1
Replies
5
Views
518
Brian S
Brian S

Part and Inventory Search

Sponsor

Back
Top