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!

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

Using number parameters in a formula to get a percentage

Status
Not open for further replies.

micheleg

Technical User
Feb 25, 2005
10
US
I hope someone can help:
I am using crystal 10 with sql, my problem report is using two number parameters. I want to be able to use the two parameters in a formula is get a percentag.
The factor in my report is the selling day. Example if there is 22 (monday-friday) selling days in january and I run the report on january 2nd, first parameter prompt is:
Parameter 1: Number of Selling Days ie. 22 and the second prompt is the day number: Parameter 2: Selling Day is 2.
My next step is the get the percentage of those two parameters for conditional color fomating to determine percentage of sales goals. Works perfect in excel, but I need it to work in crystal 10.
Really need this to work, glad for the help.
 
This is unclear. Percentage of what? Total Goal? So are you looking for something like this?

Goal * ({?Day}%{?SellingDays})

Not sure what you want to color or based on what.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top