Recent content by DomP

Skip, Thanks, I started rounding ,2 from the beginning of the calculation and that seems to be doing the trick. Thanks for all your help with this. Dom

Skip, Yes, that's what my second sentence outlines. The formatting/display of the value is different than what is actually used for calculation. Is there a way to combat this? I just can't remember running into this before. Thanks

Yes, I'm following where you are going but the quotient is stored in a cell defined with 0 decimals so the value is actually 9% or .09. These five values are then averaged producing a similar percentage with no decimals. Are you stating that what I'm showing as 9% and what is actually be...

C20 = 103,342 C26 = 9,000

Are you familiar with the link below? I ask because the percentages that are being provided are coming from formulas that look like this: =IF(C26=0,"0%",C26/C20) The c20 is the total from the pivot table and the c26 is a sum from select fields in the pivot table...

Hi Skip, For example. The percent value = 27.23% or .2723 * 28,000,000 The result should by 7,624,400 I get 7,624,820.06 $420.06 difference Dom

I am adding percentage values. These cells are NOT part of a pivot table but their values are calculated from pivot table cells. Option 1: =SUM(B22:F22)/5 Option 2: =(B21+C21+D21+E21+F21)/5 I then take the result from above and multiply this by a fixed value in another cell. The results...

Victoria, Thanks for your help. FWIW --- Just an update in case you experience this. After opening an incident with Microsoft they informed us that this is a known issue. I can't say if everyone experiences it however. It turns out that the slow login is caused because of too many entries in...

Yep, switching companies, and yes, happens on the server as sa.

We are using GP 9 Standard on a SQL 2000 Standard box. Single processor Xeon 3.06 with 3 gigs of ram. We have approx 25 GP databases running on this server along with 25 in another SQL application. It takes minutes to switch from one client to the other in GP so I'm wondering if there could...

Skip, Thanks, that should do it. Dom

I have an excel document that is utilizing various crosstab queries that are timeframe driven. Basically month and year. There are various months that have no data but I need the month to appear anyway. How can I force the month row to appear even if there is no data? 2005...

rjoubert, Tried =Sum([PERCENT USED]) but get a syntax error. Dom

I am trying to sum/total/add (whatever) a perentage value. This value is being pulled from a query. Haven't been able to get this to work. 2.5 3.5 4.0 --- 10.0 Also, what is the easiest way to round a percent to a whole number? 2.4 = 2 and 2.5 = 3? Thanks, Dom

We're not a large company (under 100) and was wondering how most organizations handle the providing of PDAs or Blackberry type devices. Is this purely a company expense, shared expense or individual expense? Thanks, DomP