% issue

[pungigi]

This is probably something very simple but my brain is on overload right now.

I have a formula that divides

Sum Count of trips (plan)/Sum Count of trips (call center)

I want it to return a %, it does but it doesn't look right, for example...

101827/102942 returns 1.00% but is really 98.91%

Can anyone help with this.

 

[IdoMillet]

Crystal % formatting doesn't take care of multiplying the number by 100. You need to do this yourself.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[bdreed35]

Change your formula to this:

(Sum Count of trips (plan)/Sum Count of trips (call center))*100

~Brian

 

[pungigi]

Thanks, works great.

 

[lbass]

Or just do:

Sum Count of trips (plan) % Sum Count of trips (call center)

-LB