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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Having CR calculate info

Status
Not open for further replies.

auburnfan

Technical User
Jan 4, 2006
22
0
0
US
Is it possible to make CR calculate information?
What I have is it is pulling up the information of amount of hours spent doing a job, I need to multiply each hour by 125 and I need it to show me the result.
Any suggestions?
oh yeah version is 9.2
 
Hi,
Yes..Create a formula thet does the math..Lik ethis for instance..

@HoursX125
{datafieldwithhours}* 125


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
I tried that but it didnt work quite right.
Here is what I did.
{datafieldwithhours} > 0.00 (this pulls up the calls with more then 0 hours.)
Now I need to multiply the number of hours by 125. so I did this
{datafieldwithhours} > 0.00 * 125
but all of my information vanishes when I do this.
Sorry, for my ineptness I have only been working with this for about a week.
 
Hi,
Do not put the math in the selection criteria..

Create a separate formula and place it in the details..


[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top